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.
N4329XS&S Aircraft Inc · Bennington, VTN4329YDetert Bradley · Valparaiso, INN4329ZWalters Leif C · Wasilla, AKN432AAAoa Kissimmee Inc · Kissimmee, FLN432ABWisco Flyers LLC · Middleton, WIN432AEArnold Neil · Caro, MIN432BEvans Ferguson · Washington, DCN432BAAnderson Jerry J · Vacaville, CAN432BRBakken Rotors LLC · Sidney, MTN432CACivil Air Patrol · Maxwell Afb, ALN432CBAlltrade Aviation LLC · Fort Branch, INN432CDVlahos Aviation LLC · Destin, FLN432CMFuller Carl C · Fairplay, MDN432DBDepcinski Travis A · Fairbanks, AKN432DGBiddle Dave S · Cave Creek, AZN432DLWhitecotton William W · Eldersburg, MDN432DMRegistered aircraftSale reported, pending cancellationN432DRJazz Air LLC · Melbourne, FLN432DSButler Jeffrey W · Santaquin, UTN432ELazy J Aeroplanes LLC · Beverly, WVN432ERUnicorn Wings LLC · Cary, ILN432FMRegistered aircraftN432HPFuehrer Wyatt R · Coatesville, INN432KCKjomo Aviation LLC · Ocean Springs, MSN432LCCardinal Roots LLC · Middletown, DEN432LELeading Edge Flight Academy LLC · Bend, ORN432MBJenks Jesse Basil · Cambria, CAN432MEEdwards Michael S · Sacramento, CAN432NCHerbert Jason Brian · Saginaw, MIN432PCRace Scott Ritchie · Odessa, TXN432PWSimple Aviation LLC · Suwanee, GAN432RADirect Entry Holdings LLC · Port Richey, FLN432RRFirst Plane LLC · Erie, PAN432RVShort Thaddeaus Allen · Conroe, TXN432SUlman Morrison · San Carlos, CAN432TVenturino Michael Trustee · Belmont, CAN432TSModern Air Solutions LLC · Panama City Beach, FLN432TTBeam John A III · Old Hickory, TNN432ZBaronhawks LLC · Jacksonville, FLN433Precision Air Inc · Manning, SCN4330DHildebrand David S · Albuquerque, NMN4330QSouthwest Aviation Specialties LLC · Tulsa, OKN4330RBellinger Joshua · Monterey, CAN4330TBc 180 LLC · Chouteau, OKN4330ZOcean Aerial Ads Inc · Ocean City, MDN43311Myers James · Coolidge, AZN43314Gardners Guns & Mfg LLC · Elk City, OKN43316Double M Aviation LLC · Lakeland, FLN4331BParker Charles B · Fort Myers, FLN4331CLance Air Inc · Taylorsville, KY
Back to AD 2007-04-19 R1