AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N19JHRegistered aircraftAssigned, pending cancellationN19JJJones James A · Odessa, TXN19JKA P Air LLC · Wilmington, NCN19JPSheldon Law Pllc · Scottsdale, AZN19JZDougrace LLC · Wilmington, DEN19KCGrays Bay LLC · Warrenton, ORN19LGTail Chaser LLC · Wilmington, DEN19MGGinsberg Matthew L · Longmont, CON19MVSky Path Aviation LLC · Sheridan, WYN19NFHuish Park City Condo LLC · Holladay, UTN19PDApd Aviation LLC · Ada, MIN19PEN19pe LLC · Stone Mountain, GAN19PFTac'S Enterprise LLC · Ballston Lake, NYN19PWN19pw Incorporated · Wilmington, DEN19RDDennison Ronald Walton Trustee · San Jose, CAN19SCSacred Heart Medical Group Inc · Riverside, CAN19SDMckenney Bret K · Billings, MTN19SERegistered aircraftN19SQZeff Aaron M · Glenbrook, NVN19TAFun Flyers LLC · Salem, ORN19UBas Part Sales LLC · Greeley, CON19UPBergeson Michael · Rocklin, CAN19WAMcphillips Flying Service Inc · St James, MIN19WHMoore Walter Robert · Naperville, ILN19XCDubose Mack · Edmonds, WAN1ACEaa Aviation Foundation Inc · Oshkosh, WIN1AJJenkins Arthur J · Kila, MTN1ANConnelly Robert I · Blowing Rock, NCN1ATAircraft Guaranty Corp Trustee · Oklahoma City, OKN1BYWigen Mary E · Porthill, IDN1GESonburst Aviation LLC · Mission Viejo, CAN1GLSmith Alfred N D IV · Lake Wylie, SCN1GVVanremortel Gary R Trustee · Milpitas, CAN1GWWheeler George H · Montgomery, TXN1GXOclair Carleton Brent · Saco, MEN1HMGlasscock Charles W Jr · Elm Grove, LAN1HWDiaz Jorge Lino · Hialeah, FLN1JDAero Aircraft 10 LLC · Jacksonville, FLN1JEWillis Nelson W · Lebanon, TNN1JQJacquot Daniel C · Colorado Springs, CON1KJMartin Ronny D · Duncan, OKN1LCIndrebo Jase S · Fair Oaks, CAN1LLC&L West Coast Flyers LLC · Dixon, CAN1LMArmstrong Robert B · Bishop, GAN1LPRegistration Pending · Lynn Haven, FLRegistration pendingN1LRFoster Darrell R · Hickory, NCN1LUBoho LLC · Lewes, DEN1LYAll About Lawns Inc · Sebring, FLN1MPFly One Mp LLC · Omaha, NEN1NNWorlds Greatest Aircraft Collection Inc · Polk City, FL
Back to AD 2006-10-21