AD 77-01-01
Registered aircraft · 16,382
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:77-01-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-01-01')
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:77-01-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-01-01') 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.
N111CPVelasco Ricardo Rene Jr · Cumming, GAN111DJLee Brian A · Riverdale, GAN111EMMccue Inc · Florence, MTN111FBMccarthy Elaine M · Indianapolis, INN111FCWoody Air LLC · Vero Beach, FLN111FPPhoenix Carolina LLC · Saint Petersburg, FLN111FRAirward Inc · Novato, CAN111NPBlackfoot Aviation LLC · Bozeman, MTN1121XCrosscheck Ftc LLC · Greeneville, TNN1122ACox Abraham · Key West, FLN1123WThiel Jonathan Ronald · Billings, MTN1125TSpruce Tiger Aviation LLC · Dallas, TXN1125XApm Leasing LLC · Casper, WYN1126HHead Lewis T · Portland, TNN1126QGibbs Robbie Douglas · Lacombe, LAN1126XBolobonoff Alexander G · Kingman, AZN112JMGuzman John · China Spring, TXN112JRValleau Matthew J · Wallingford, CTN112LGAb Prop Plane I LLC · Metairie, LAN112WMInternational Air Services Inc Trustee · Carson City, NVN1132QWattum Investments LLC · Kodiak, AKN1138FSky West Aviation Inc Trustee · Albuquerque, NMN1138XPierce Nathaniel Antonio · Magnolia, DEN113EJIxi LLC · West Bloomfield, MIN113GAtp Aircraft 9 LLC · Wilmington, DEN113HMAkins Tal M · Register, GAN113KRIal Corp · Lewes, DEN113SWFargo Jet Center LLC · Fargo, NDN113WYRyals Barry · Rhine, GAN1140XReaper LLC · Britton, MIN1142QSteely Paul · Williamsburg, KYN1144XFly Texas Sky LLC · Arlington, TXFirst renewal noticeN1144ZBay Lux Ventures LLC · Tampa, FLN1146HLtk Air Inc · North Wilkesboro, NCN1147XPax Flyers LLC · Hollywood, MDN114CFAw Chartering LLC · Franklin, TNN1150XVenture North Aviation LLC · Cloquet, MNN1154XKelley Jay D · Lake Havasu City, AZN1157XAscend Aviation LLC · Bountiful, UTN1158HOs Flight LLC · Double Springs, ALN1159XBarrett Tyler J · Cullman, ALN115DCLong Jerry D · Solvang, CAN115DXPiper Aircraft Inc · Vero Beach, FLN115JAFarmer Stephen E · Tullahoma, TNN115TWYale Companies LLC DBA · Indianapolis, INN1160UPiper Aircraft Inc · Vero Beach, FLN1160XWagner Robert J · Dubuque, IAN1161HEngert Armin L · Kahului, HIN1161XBarnett Donald R · Atoka, TNN1163XPerry Curtis · Klamath Falls, OR
Back to AD 77-01-01