AD 81-18-04 R2
Registered aircraft · 81,733
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-18-04-R2')
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-18-04-R2')
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-18-04-R2') 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-18-04-R2') 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.
N57777Thorsgard Keith A · Mcville, NDN5777LSessums David L · Seabrook, TXN5777UFossa Matthew A · Pensacola, FLN5777VDe La Garza Jimmy · Granbury, TXN5777WMaschek Anothony Q · Killeen, TXN57787Shoultys Shawn P · Denali Park, AKN5778PHunton Hugh R II · Midlothian, TXN5778QPars Avn Corp · Wilmington, DEN5778VGlenn Larry D · Reynoldsburg, OHN5778ZWhelan Cynthia Vs · Seneca, SCN57792Arizona Game & Fish Dept · Phoenix, AZN5779DAltenburg Scott J · Anchorage, AKN5779FScheer Abraham · Milton, DEN5779HKelly David L · Pendleton, ORN5779PLechner Kevin P · Wurtsboro, NYN5779ZSvec Adolph R · Marengo, ILN577AUBeck Patrick · Algonquin, ILN577BASpitzer Helicopter LLC · Woodland Hills, CAN577CMEllison Ranching Co · Elko, NVN577DPLustfeldt Gordon L · Normal, ILN577EREmbry-Riddle Aeronautical University Inc · Prescott, AZN577FAN577fa LLC · Redondo Beach, CAN577FCFlight Club · Middle River, MDN577FGRidgeline Assets LLC · Wilmington, DEN577FLMorsi Sameh M · Pomona, CAN577JLJaj Aviation LLC · Plano, TXN577MBBlalock James M · Sheridan, ARN577NDAir Shares LLC · Casper, WYN577SPTexas State Technical College · Waco, TXN577TMoore Eric C · Cave Creek, AZN577TZWestbank Fishing LLC · Kiln, MSN577ZZRubey Arthur C · San Antonio, TXN5780FAces Aviation LLC · Laurel, MTN5780HPlane Fun Inc Tr Trustee · Snellville, GAN5780PWall Scott · Franksville, WIN5780QMuegge Erik L · Keller, TXN5780WSmoyer Justin L · Slatington, PAN5780ZBergstrom Robert L · Amelia Court House, VAN57816North Texas Dusters & Sprayers Inc · Gainesville, TXN5781FRegistered aircraftN5781QFranklin Mountain Group Corp · Nashville, TNN5781WPietras Aaron E · Franklin, INN5782FMission Aviators LLC · Spring, TXN5782HTomas Douglas J · East Troy, WIN5782JN5782j LLC · Myrtle Beach, SCN5782PPaviation LLC · Lewes, DEN5782QSkylions LLC · Wichita, KSN5782VDave Sheets And Sons Contracting Inc · Columbia City, INN5782WDavis Clinton · Baldwin City, KSN5783FBate Eric D · Vancouver Bc
Back to AD 81-18-04 R2