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.
N298GBSandhu Harpreet · Livermore, CAN298GTOctopus Flying Club Inc · Riverdale, MDN298HPPendergrass Inc · Demopolis, ALN298JBank Of Utah Trustee · Salt Lake City, UTN298JCNiemeijer Meindert · Coralville, IAN298JSBoisselle Joeph C · White Swan, WAN298MASouthern Air Service Inc · Carbondale, ILN298MCJ C B Aircraft Sales And Leasing · Princeton, NJN298MEVermont Flight Academy Inc · South Burlington, VTN298MGGeorgia Aviation Authority · Eastman, GAN298MHPack Flight Services LLC · Groveland, FLN298NDNational Training 1 LLC · Wilmington, DEN298PAir-Spacers Inc · Santa Monica, CAFirst renewal noticeN298PEPhoenix East Aviation LLC · Daytona Beach, FLN298PWMedina Ruben F · Foothill Ranch, CAN298RVLee Duncan A · Glen Burnie, MDN298RWPettus Gary A · Fort Mill, SCN298SAFb Aviation Services LLC · Wilmington, DEN298SCCharlie Aviation LLC · Oregon City, ORN298SHHeising Sean Allen · Billings, MTN298SMSmb Flyer LLC · Queen Creek, AZN298TTruair LLC · Chaska, MNN298TAIslander Holdings Ltd · Fort Lauderdale, FLN298TCOlson Tom C · Cedar Rapids, IAN298VBEdholm Joseph · Lino Lakes, MNN298ZRepella Theodore J · Townsend, DEN2990L&L Aviation Inc · Advance, NCN2990ATottle K M DBA · Limington, MEN2990CLyng Stephen G · Kenosha, WIN2990DHall Tyson · Leadville, CON2990KGundersen Timothy A · Henderson, NVN2990TStahl Bradford C · Jackson, CAN2991DWatkins William C · Guy, ARN2991FBerryessa Alan E · Cedarville, CAN2991PHofer Todd Paul · Doland, SDN2991TRothgeb Michael A · Burns, ORN2991XDewald David J · Fort Wayne, INN2991YRabska William G · Suisun City, CAN2992GYonge Charles Richard · Ocala, FLN2992HSale Reported · Manchester, NHSale reported, canceledN2992PLowe Danny D · Wasilla, AKN2992RSolrei Inc · West Palm Beach, FLN2992TMeyers 200 LLC · Malden, MON2993CFrei Jayci N · Grangeville, IDN2993FDaniels Aviation Inc · Inverness, MSN2993GKilgore Samuel E Jr · Southaven, MSN2993LGoutell Carl R · Marco Island, FLN2993RSell Carl N · Spanaway, WAN2993TElghammer Garrott W · Niles, MIN2993XKreutzer Charles · Springfield, IL
Back to AD 2007-04-19 R1