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.
N3114RCrews David Mason · Manteo, NCN3114TClark Thomas J · Saint George, UTN3114VWheeler Jack W · Greensboro, NCN3114XNorthgate Aviation Inc · Chico, CAN3114YN635v LLC · Nacogdoches, TXN3115Bravo Charlie LLC · Johnston, IAN3115ASuits Jerry L · Tulsa, OKN3115DSmith Gregory · Lewistown, MTN3115FTritec Air LLC · Tower, MNN3115QThomas Charles S · Barstow, CAFirst renewal noticeN3115SHamric James H · Ward, ARN3115WBenson James M · Cleveland, TNN3116Dart Gregory G · Mayville, NYN31161Zerbe Monte K · Dayt Bch Sh, FLN3116QHenderson State University · Arkadelphia, ARN3116RWoodruff James Michael Richard · Wasilla, AKN3116SRose David J · West Mansfield, OHN3116WMathis Bettina Jary · Dripping Springs, TXN3116YGorrell Nena S · Madison, ALN3117Daacke Edwards J · Glen Rock, PAN3117AAtp Aircraft 8 LLC · Wilmington, DEN3117DTwin Oaks Aircraft Maintenance LLC · Hillsboro, ORN3117FBrya Troy · Roscommon, MIN3117LAtp Aircraft 2 LLC · Wilmington, DEN3117TWalker Sean Michael · Apple Valley, MNN3117ZYoung Donald L · Anniston, ALN31183Ial Corp · Lewes, DEN3118CChristensen Effie S · Wasilla, AKN3118DNau Howard A · Melba, IDN3118FReining Jonathan W Trustee · Piedmont, CAN3118HAtlantic Aviation Group Inc · Miami, FLN3118KNorth Carolina Wildlife Resources Commission · Raleigh, NCN3118QVercoe Trevor · San Clemente, CAN3118RLivesay Wallace B · Friendswood, TXN3118SMccormack Nicole E · Greenwood, CAN3118TButts Thomas E · Alma, GAN3118UMaytown Sport Parachute Club · Marietta, PAN3118YTeerlink Craig N Trustee · Cedar Hills, UTN3118ZTridogs LLC · Cleveland, GAN31192Silverhawk Aviation Academy LLC · Caldwell, IDN31197Cournoyer Professional Contractors · Port Orange, FLN3119FAbsolute Fencing LLC · Granger, WAN3119KHangar 21 Aviation Inc · Lake Havasu City, AZN3119PKovacs Thomas A · Nashua, NHN3119RChern Jeffrey · Oakland, CAN3119SFinch Michael J · Springfield, TNN3119TRiverwind Strategic Solutions LLC · Lewes, DEN3119XReese Travis A · Glade Park, CON3119ZStoner Paul V · Austin, TXN311AKN46132 Leasing LLC · Kalispell, MT
Back to AD 2007-04-19 R1