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.
N56325Glaser John · Merritt Island, FLN56326Abernathy Spraying Service Inc · Tipton, OKN56328Registration Pending · Camarillo, CARegistration pendingN5632AHerrin David R · Patterson, GAN5632NCastle Brian B · Craig, AKN5632RInternational Air Services Inc Trustee · Carson City, NVN5632SRutherford Keith D · Bossier City, LAN5632USale Reported · Montgomery, ALSale reportedN56332Smith Paul G · Wasilla, AKN56335Maule Air Inc · Moultrie, GAN5633BGood Airplanes LLC · Oshkosh, WIN5633HDunne Terence J · Wasilla, AKN5633LCavenagh Thomas D · Lawton, OKN5633PPride Lawrence E · Poway, CAN5633QKeene John D · Spotsylvania, VAN5633SQualitair LLC · MichelstadtN5633UStaples Clint B · Glen Rose, TXN5633WWenzel Mark B · Algona, IAN5633ZMulder Gene D · North Sioux City, SDN56343R&T Wings LLC · Lewes, DEN56344Rogers Steve M · Brenham, TXN56347Smith Dale · Windsor, CAN5634PWaters George A · Oklahoma City, OKN5634QLegacy Aero LLC · Jonesboro, ARN5634SSmb Air Inc · Crescent Springs, KYN5634WEagle Vision LLC · Hamer, IDN5634YPottenger Charles R · Lewiston, IDN56350Aerospace Technology Group Inc · Temecula, CAN56353Groux Zachary Brian · Spring, TXN56355Vectair USA LLC · Olive Branch, MSN5635DZuber Gary D · Culver, ORN5635ECircle W Flying Club Inc · Creighton, PAN5635MGlenn Brian J · Boise, IDN5635NMann David · Glenn, CAN5635SRhodes Stephen · Hayti, MON56363Romzick Peter G · Oxford, MIN56366Kerby Ryan S · Talkeetna, AKN56367N56367 LLC · Manassas, VAN56368Performance Aircraft Sales Inc · Lincoln, NEN5636DSorensen R L · Soda Springs, IDN5636GTres Locos Gringos LLC · Lubbock, TXN5636HRobertson James S · Welsh, LAN5636MThorpe Caleb D · Las Vegas, NVN5636NSummit Aviation Holdings Of Nwa Inc · Rogers, ARN5636PBarley Austin D · Red Lion, PAN5636QKelly Thomas J · Henderson, TXN5636UMontie Michael · Fairview Park, OHN5636WWatkins Micah · Queen Creek, AZN56370Grosgebauer Bryan R · Ogden, UTN56371Guenther Harry D · Grove City, PA
Back to AD 2007-04-19 R1