AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N311SKDoyle Thomas Michael · New City, NYN311SSSeabolt Pilots LLC · Cave City, ARN311TLM & N Enterprises LLC · Topeka, KSN311XStevens Adam · Dacono, CON311ZRegistration Pending · Rockford, ILRegistration pendingN31200N7775mw LLC · Sand Lake, MIN3120FLengyel Roger · Santa Fe, NMN3120MCowtown Aviation LLC · Aledo, TXN3120QLinda In The Sky LLC · Webster, MNN3120RBulang Investments LLC · Newbury, NHN3120WWiese Chuck F · Portland, ORN3120ZGifford Thomas Lloyd · Canadian, TXN31216Valley Aire Inc · Marlboro, NYN3121DFrey Jerry P · Fallon, NVN3121FLily Chris H · Ocala, FLN3121LBeckham Stephen · Canby, ORN3121THall Tyler · Billings, MTN3121VCochise Community College · Douglas, AZN3121WAlpha Dog Aviation LLC · Marco Island, FLN31228Hauser Dean · Stratford, TXN3122EKantec Inc · Cary, NCN3122LE C G Aviation Inc · Orange, CAN3122MMiller-Jackson Co Inc · Oklahoma City, OKN3122RMarrow Henry G · Southern Pines, NCN3122STecumseh Skydiving School LLC · Tecumseh, MIN3122UTravel Aviation Inc · Vineyard Haven, MAN3122YJti Management LLC · Colfax, WAN3123CRmc Aviators LLC · Wilmington, DEFirst renewal noticeN3123EKanase Padmaneel B · Amarillo, TXN3123QDarkhorse Six Inc · Boerne, TXN3123RHs Aviation Holdings LLC · Eagle, IDN3123SGabin LLC · Tulsa, OKN3123WSullivan Dan · Kingwood, TXN3123YAbecca Corporation · Jackson, MIN3123ZTripp Robert L · Walsenburg, CON31241Hotel Charlie Aero LLC · Marshville, NCN3124DBurch David C · Flushing, MIN3124FTrue Aviators LLC · Kiowa, KSN3124RMidland Liberty LLC · Midland, MIN3124VBonanza/Baron Museum Staggerwing Museum Foundation · Tullahoma, TNN3124WBaron 24w LLC · Outing, MNN31252Buchholz Claus W · Haslett, MIN31256Mason Crosby H · Zebulon, NCN31257Lea Nathan · Belgrade, MTN3125DDavis Ronald L Jr · Soldotna, AKN3125FHall Aircraft LLC · Kenai, AKN3125LOxley Lake Solutions LLC · Lawton, MIN3125QSunrise Aviation Llp · Gig Harbor, WAN3125THamilton Brian H · Currie, MNN3125UAlba Leasing Services LLC · Scottsdale, AZ
Back to AD 2007-04-19 R1