AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N35188Landsearch LLC · Wilmington, NCN3518BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN3518FPortmann James R · St Louis Park, MNN3518YMcaninch Shawn R · Albia, IAFirst renewal noticeN3519YWeber Larry F · New Paltz, NYN351BRRosenbaum Robert · Chilmark, MAN351CACivil Air Patrol · Maxwell Afb, ALN351CPCivil Air Patrol · Maxwell Afb, ALN3520FWood Forrest B · Cookson, OKN3520USchioppo Joseph · Boynton Beach, FLN3521KState Of North Carolina · Raleigh, NCN3521YSportsman Airpark Inc · Newberg, ORN3522UDfs · Bountiful, UTN3522YBohlen Thomas R · Hudson, WIN3523UCharlson Aaron H Jr · Forest City, IAN3524FRegistered aircraftN3524UHudson George R · Hueytown, ALN3525FR&R Aviation · Gunnison, CON3525RCrabtree Jeremy Adam · Atlantic Beach, NCN3526FHaskett Steven E · Austin, TXN3526UThomason Tommy Eugene Trustee · Scottsdale, AZN3527FTuorila Tony C · Anderson, SCN3527YHrobak Robert F · Winter Garden, FLN3528CAlvarez Fernando Perez · Santan Arecibo, PRN3528DBank Of Utah Trustee · Salt Lake City, UTN3528FFair Paul R · Vacaville, CAN35291Rochon Everette · Wesley Chapel, FLN3529NOken Andrew · Corvallis, ORN352CPCivil Air Patrol · Maxwell Afb, ALN3530FHeames Scott D · Simi Valley, CAN3530UKalmbach Justin J · Polson, MTN3530YScollon Brian F · Hudson, COFirst renewal noticeN3531YPetter David · Stuttgart, ARN3532KHattell George Curtis · Olympia, WAN3532LPiab Inc DBA · Fresno, CAN3533YFarley Sean D · Anchorage, AKN3534FLackie Paul C · Melbourne, FLN3537FWatson James L · Burke, VAN3537YCaton Robert M · Stafford, VAN3538FGospel Ministries International Inc · Collegedale, TNN3538UVan Bilsen Aero LLC · Boise, IDN3539EGordon Robert A Jr · North Pole, AKN353AWAirflow LLC · Missoula, MTN353CPCivil Air Patrol · Montgomery, ALN353DWZephyr Aviation LLC · Greenwood Village, CON353SPBerger Amnon Asher · Westwood, MAN3540FMcevoy Rex · Custer, SDN3540YAero Leasing LLC · Rapid City, SDN3541AFogle Douglas J · Valparaiso, INN3542BHuddleston James A · Eloy, AZ
Back to AD 84-10-01 R1