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.
N328MDJames Douglas M Trustee · Scottsdale, AZN328MEFlying Start Aero Services LLC · Reno, NVN328NCHenderson Anthony B · Hoschton, GAN328PStrother J Barron · Santa Rosa Beach, FLN328PMMayworm Patrick · Mclean, VAN328RHEchemendia Joel · Kissimmee, FLN328SFast Flight Inc · Springdale, ARN328SGUp Lights LLC · Jacksonville, FLN328SSUnited Helicopter Leasing LLC · Honolulu, HIN328TASuburban Air Corp · Castro Valley, CAN328TRRufi Craig · Thousand Oaks, CAN328VRotors Away LLC · Bayside, NYN328ZPellicone Scott V · Millstone Township, NJN32903Foxtail Aviation LLC · Orefield, PAN32904Sheidler Randy L · Gallipolis, OHN32906Benson Brian R · Mauston, WIN32909Zamarripa Hector · Brownsville, TXN3290QCape Fear Aviation Maintenance LLC · Fayetteville, NCN3290XBirman Pablo E · Suamico, WIN3291EKukuchka Ronald G · Tunkhannock, PAN3291FEvans Derek M · Fresno, CAN3291SRegistration Pending · Highland, ILRegistration pendingN3292FGoodwin Darrell W · Richmond, TXN3292MHyannis Air Service Inc · Hyannis, MAN3292PCrosswindz Ranch LLC · Seminole, TXN3292TCelestial Kinetics Flight Academy LLC · Waupaca, WIN3292UAnnecchini Frank C Jr · Overland Park, KSN3292WOldenkamp Daryl · Hermosa Beach, CAN3292ZAlbertson James M · Westville, FLN32932Gilbert Roy S · Mechanicsville, VAN3293BHuttunen Alice D Trustee · Wasilla, AKN3293DGuilliams Carl · Gilbert, AZN3293FYe Xiaofeng · Los Gatos, CAN3293QRegistration Pending · Gainesville, TXRegistration pendingN3293RBrook Jacob C · Broken Arrow, OKN3293VMckinney Brian · Lakeville, MNN3293YKiedinger John D · Burleson, TXN3293ZStraight And Leve Aeromedical LLC · Billings, MTN32942Bent James L Jr DBA · Palatine Bridge, NYN32947Alpe Holding LLC · Van Nuys, CAN3294CNorwood Kent L · Springfield, MON3294FWatkins Grant M · Durant, OKN3294RMurray Dennis P · Malta, NYN3294TWolniansky Peter W · Ocean Grove, NJN3294UWidener Christine A · Tucson, AZN32956Meritt Kendall E · Wayne City, ILN3295WChapman Daniel H Jr · Ontario, CAN3295YReid Brian M · Boise, IDN32969Henry Robert K · Knoxville, TNN3296BCommand-Aire LLC · Coatesville, PA
Back to AD 2007-04-19 R1