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.
N3241YNull James A III · Live Oak, TXN32421Anderson Allen D · Goodlettsville, TNFirst renewal noticeN32425Montgomery Robert L · Kingman, AZN32426Fly Aviation LLC · Sabetha, KSN32427Mcfadden Robert K · Port Orange, FLN3242CPelski Aviation LLC · Ocala, FLN3242FSbflyer LLC · Ooltewah, TNN3242KPorter Thomas G · San Carlos, CAN3242RRobertson Dale R · Newton, KSN3242SBateman Amber · Elizabeth City, NCN3242TSt Clair Ronnie M · Cochise, AZN3242YShadow Air LLC · Norfork, ARN32435Nickos Ryan L · Kenosha, WIN32436Townsend Ricky E · Rogers, ARN32439Triple R Aviation LLC · Cleburne, TXN3243BKcirro LLC · Portland, ORN3243COrthopaedic Surgery Institute Of California Mc · Newport Beach, CAN3243UGlobe Motorcycles Ltd Inc · Pembroke Pines, FLN32440Ford Chase Rambo · Montgomery, ALN32441Registration Pending · Kalispell, MTRegistration pendingN32444Jtz Aviation LLC · Wilmington, DEN3244DBrooks Laura · Palmer, AKN3244FKempton Brian J · Huntsville, TXN3244TCaicedo Oscar E · Garner, NCN3244YCutrell William J · Mc Donald, TNN3244ZGinn Robert Theron · Royston, GAN32452Watkins Nathan · Baytown, TXN3245QTandy Richard L · North Chili, NYN3245RA & W Cattle Co · Flippin, ARN32462Av8 Flight Services LLC · Wichita Falls, TXN32466Oh Heung Taeg · Olney, MDN32469Dufresne Justin Barth · Temple City, CAN3246BRb3246b LLC · La Follette, TNN3246DJaden H Erwin Dds Pllc · Helena, MTN3246EKauffman Gerald E · Bedford, PAN3246HBarnhill Gregory L · Leawood, KSN3246RRegistered aircraftN3246TFears Edwin G III · Trafalgar, INN3246UGregory Group LLC · Norwalk, CTN32475Eikenberry Don A · Palouse, WAN32478Sidney Aviation LLC · Sidney, NEN3247FWilliams Matthew D · Xenia, OHN3247PCary Leasing & Management LLC · Boerne, TXN3247RArrowood Bradley W · Winston Salem, NCN3247TBeeda Mark A · West Palm Beach, FLN3247XExcalibur Aviation LLC · Spencer, IAN32480Alphakiloecho LLC · Somerville, MAN32481Flyboy Fantasy Inc · South Lake Tahoe, CAN32483Showah Jason M · Brentwood, TNN32486Parr Bobbie D · Mount Pleasant, TX
Back to AD 2007-04-19 R1