AD 81-04-05 R1
Registered aircraft · 1,079
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:81-04-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:81-04-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:81-04-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:81-04-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.
N62553Pacific Fleet Aviation LLC · Rochester, NYN62557Yukon Intermountain Inc · Anchorage, AKN62564Del Mar College · Corpus Christi, TXN6257HFinck Michael · Port Charlotte, FLN6257YDavila Rudolfo G · Runge, TXN62593Samco USA LLC · Reno, NVN62599Raw Enterprises Inc · Lewes, DEN625YCMatthews Grover C · Fairborn, OHN62607Horizon Aeronautics · Columbia, SCN62625Registration Pending · Buffalo, MNRegistration pendingN6262HLle Aire LLC · Cocoa, FLN62641Systir Aviation LLC · Pittsburgh, PAN62647Pacific Fleet Aviation LLC · Rochester, NYN62650Lpc Aviation Inc · Punta Gorda, FLN62654Skylens LLC · Hammond, LAN62665Murvin Theoren J III · Winter Garden, FLN62677Kersey Brian A · Pulaski, TNN62688Blair Leonard · Fleetwood, PAN62697Edwards Benjamin F · La Canada, CAN62699Antelope Valley College · Lancaster, CAN6269YN6269y Six Place LLC · Miami, FLN626BFVenture North Aviation LLC · Cloquet, MNN626SPJoye Robert M · Casa Grande, AZN62707Registration Pending · Piedmont, SCRegistration pendingN62745Pacific Fleet Aviation LLC · Rochester, NYN62756Red State LLC · Daytona Beach, FLN62757Delaware Aircraft Trust LLC Trustee · New Castle, DEN62787Williamsburg Air Service Inc · Kingstree, SCN627JKUlrich Sandy J · Haskell, OKN62801Pacific Fleet Aviation LLC · Rochester, NYN62802Hannair LLC · Titusville, FLN62804Hill Adam John · Bethlehem, GAN62807Neal Aircraft Inc · Slaton, TXN62808Wings Over Texas Holdings LLC · Denton, TXN6280YJ & S Of Wi LLC · Iola, WIN62812Facer Insurance Agency Inc · Rantoul, ILFirst renewal noticeN62818Pollack Matthew · Falls Church, VAN62823Mcmillan William K · Jamestown, NDN62829Cor Yan · San Juan, PRN62835Paperd Rex A · Fall City, WAN62836Pacific Fleet Aviation LLC · Rochester, NYN62840Emond Ronald L DBA · Nashua, NHN6299YT&T Aviation LLC · Clarksville, TNN62ADHawkins Flight Academy LLC · Shelbyville, TNN6321YHallstein Roy M · San Jose, CAN6334YHofer Perry L · Doland, SDN63398Norman Robert A · Zanesville, OHN633WSGilmores Glorious Goods LLC · Lewes, DEN6353YAlpine Aviation LLC · Oasis, IDN6355YSky West Aviation Inc Trustee · Albuquerque, NM
Back to AD 81-04-05 R1