AD 2007-04-19 R1
Registered aircraft · 108,434
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N333FVGreco James L · Mount Pleasant, SCN333GKCenturion210 LLC · Amherst, NHN333GTTriplett Gregory S · Groveland, CAFirst renewal noticeN333HADoran Jeff · Westerville, OHN333HJSchlender Mike · Clintonville, WIN333HMVia Vitae Aviation LLC · Lexington, KYN333HRWilson Alan E Trustee · Erie, CON333HTTiernan Barton M · Anchorage, AKN333HYFrantz Paul B · Abbeville, GAN333JCHunter Prim LLC · Bolingbroke, GAN333JDMountain Mojo Aviation LLC · Banner Elk, NCN333JEJs Aviation Inc · Valparaiso, INN333JFWolfe LLC · Rogers, TXN333JGCuthbert Victor W · Dowagiac, MIN333JMKahl Fredric P · Monmouth, MEN333JPSpeece Ryan J · Vero Beach, FLN333JSWarbird Adventures Inc · Ocoee, FLN333JWPhillips John Patrick · Cumming, GAN333KMParker Michael A · Fowler, INN333KNKris Noone Air LLC · Wilmington, DEN333KRSimmons Anthony T · Easley, SCN333LB333lb LLC · Fort Worth, TXN333LESky Photoshop LLC · Winter Garden, FLN333LHKoelbl Aviation LLC · Whitesboro, TXN333LJJarrell Christopher · Lincolnton, NCN333LSBrown Richard G · Blanchard, OKN333LTGlover William S · Mount Pleasant, TXN333MGherardini Donald A · Sullivan, ILN333MABadolato Leonard · Berlin, NJN333MCGriffin Shawn P · Locust Grove, GAN333MDDunkel Matthew T · Port Orange, FLN333MHMerritt Hal S · Hilliard, FLN333MMDunlap Rodney L · Jonesboro, ARN333MTGesl Gregg R · New Braunfels, TXN333NPhillipson Justin M · Vacaville, CAN333NCCapital Flying Inc · Elk Grove, CAN333NDUnd Aerospace Foundation · Grand Forks, NDN333NTKoerner Norman H · Roanoke, TXN333PGAty Aviation Inc · Watertown, SDN333PHJ&L Management Group LLC · Lewes, DEFirst renewal noticeN333PJHawaii Pacific Aviation Inc · Kailua Kona, HIN333PKPalmer Joe A · Meridian, IDN333PLPilot Maker LLC · Hayward, CAN333PSDoran Jeffrey T · Westerville, OHN333PWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN333PYMatonti James Robert · Oklahoma City, OKN333QBAdams Chad D · Dayton, ORN333RAShepard Cameron J · Reading, PAN333REM I Aviation Inc · Juda, WIN333RFQualitair Lc Trustee · Michelstadt
Back to AD 2007-04-19 R1