AD 2000-22-18
Registered aircraft · 914
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:2000-22-18')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-22-18')
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:2000-22-18') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-22-18') 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.
N3118HAtlantic Aviation Group Inc · Miami, FLN3121WAlpha Dog Aviation LLC · Marco Island, FLN3122RMarrow Henry G · Southern Pines, NCN3124WBaron 24w LLC · Outing, MNN312CWLb Wings LLC · Midland, MIN316DFThacker Orbie A · Wellington, ALN3174BBrydon Robert J · Lago Vista, TXN3174TChartwell Services Inc · Wilmington, DEN3177WCraniatwo LLC · Peoria, ILN3178AMarine Aviation LLC · Hanover, NHN3182LN303cj LLC #1 · Lexington, KYN3187WG S Aviation Inc · Stilwell, KSN318CAKornegay Patrick · Harlingen, TXN3194XAutry Mark T · Sumter, SCN3195KEasygoair LLC · Sudbury, MAN3196WTs Aviation LLC · Sioux Falls, SDN3199JSietsma Lawrence F · Indialantic, FLN3209DCirrus 1jr LLC · Webster, NYN320WDAt Liberty LLC · Apple Valley, MNN3211UHc LLC · Troy, ALN321WMMartinez Jose A · Orlando, FLN322SACimarron LLC · Kurten, TXN323LMSandcastle Jwm Properties LLC · Paradise Valley, AZN3246BRb3246b LLC · La Follette, TNN3248LPreferred Management Corp · Shawnee, OKN324QLove Charles Keith · Asheville, NCN325DCGmg Aviation LLC · Ehrhardt, SCN3260FGilbert Aviation Inc · Wilmington, DEN3261CHeyman Steven · San Mateo, CAN3270JBerry Matthew G · Creedmoor, NCN3281KWallace Architects LLC · Columbia, MON328MN328m LLC · Marion, INN328PStrother J Barron · Santa Rosa Beach, FLN3300GAir Amg LLC · Greensboro, NCN3330MMaine Instrument Flight · Augusta, MEN333TKayair LLC · Visalia, CAN333ZXMallick Aviation Services LLC · Wilmington, DEN338TKGranite Boarding LLC · Loomis, CAN33SFRoseville Aviation LLC · Roxboro, NCN33SHDrl Baron LLC · San Augustine, TXN344RCHome Perfection General Contractors Inc · Pelham, ALN344SRegistered aircraftN345PGN345pg LLC · Chicago, ILN34SCTbhb Logistics LLC · Amarillo, TXN3509W92nd West Aviation Inc · Lonoke, ARN3566WGriffin Aviation LLC · Minneapolis, MNN358CMEathcirc 08 LLC · Tucson, AZN358YJuliet Air LLC · Cincinnati, OHN359PTilloo Aviation LLC · Pensacola, FLN360UAdrenalyne Consulting LLC · Scottsdale, AZ
Back to AD 2000-22-18