AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N63042Ting Chih-Wei · Tracy, CAN63046Lindholm Michael D · Anchorage, AKN63047Ggf Inc · Jacksonville, ARN6304HCharbonneau Thomas C · Hendersonville, NCN6304SCowey Kevin M · Pittsburgh, PAN63051Moss Ronald J · Hamer, IDN63053Claeys John T · Blue Grass, IAN63057Guerra Enmanuel M · Weirsdale, FLN6305SPrivette Hugh T Trustee · Colorado Springs, CON63062Cade Richard G · Lopez Island, WAN63066Rench Eugene G · Owosso, MIN6306GMartin Robert · Sylvester, GAN63074Charlton Jeremiah · Rockford, ILN63079Ark Aerospace LLC · Fort Walton Beach, FLN6308GDreher Easton · Wis Dells, WIN63091Hobbs Kole T · Greenville, TXN63092Lozano Jorge L · Miami, FLN63095Boyle Daniel K · Llano, TXN6309GJohnson Robert W · Lebanon, TNN6309SRegistered aircraftN630SAAnglin Marvin D Jr · Alpharetta, GAN6310EMinor Mark · Central Point, ORN6310GAerostar Management Services LLC · Kissimmee, FLN63114Rgw Aviation LLC · Wilmington, DEN6311DFraser William G · Berkley, MAN63120Dean James J · Tampa, FLN63121Aba Contractors Inc · Arcadia, OKN63122Registered aircraftN63125Registration Pending · Burnsville, MNRegistration pendingN63126Aero Marine Inc · Westland, MIN6312GAshe Robert W · Bethel, CTN63132Ha Peter · Eastvale, CAN63138Sport Flyer Service LLC · Katy, TXN6313DHoffman Edward C · Tarpon Springs, FLN6313EGottshall Curt E · Monroe, WAN63149Aviation Trust Co LLC Trustee · Oklahoma City, OKN6314EWeber Tom L · Douglas, WYN6314GKing William E · Simpsonville, SCN63150Parrish Jonathan · Boulder City, NVN63154Burleson James G · Grand Prairie, TXN63155Morten David J · Larimore, NDN63157Tadres Abanob Y · Antioch, TNN6315SDelta Delta Aviation Group Inc · New Castle, DEN63165Eagle Eye Aviation LLC · Mccomb, MSN63169Spinola Hernandes M · Homestead, FLN6316GChurch Aviation LLC · Christmas Valley, ORFirst renewal noticeN6316HJ3 LLC · Bonita Springs, FLN6316SGlobal Navigator LLC · Anacortes, WAN63179Fetch Carl Jr · Monongahela, PAN6317HYoder Donald D · Garden Plain, KS
Back to AD 94-05-05 R1