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.
N414RB4rb LLC · Roseburg, ORN414RCMenke Peter T · Augusta, MON414RDJ & S Aviation LLC · Crossville, TNN414RKAsp Aviation LLC · Macon, GAN414RMMutzman Richard C Trustee · Dublin, OHN414RNCsc Delaware Trust Co Trustee · Wilmington, DEN414RVProebstl Robert J · Torrance, CAN414RWJxc Holdings LLC · Clovis, CAN414SCPaul Sachitano LLC · Beaumont, TXN414SDHayden Stephen M · Ludlow, MAN414SEMcn Aviation LLC · San Antonio, TXN414SGCloud Niner Aviation LLC · Zephyrhills, FLN414SHNichols Farms · Seminole, TXN414SJBradley Scott · Manassas, VAN414SMSwair LLC · Cheyenne, WYN414SPDiamond Upgrades LLC · Phoenix, AZN414SR414sr LLC · Missoula, MTN414STTurnbull Timothy H · Mccall, IDFirst renewal noticeN414SWRmi Air LLC · Ocilla, GAN414TMillstreet Software Inc · Pompano Beach, FLN414TAJerry L Stephens Investments LLC · Sunset, SCN414TBTextron Aviation Employees Flying Club Inc · Wichita, KSN414TDAtlas Aviation LLC · Maple Grove, MNN414TFBlue Sky Aviation LLC · Columbia, TNN414TJLobair LLC · Peoria, ILN414TMBrar Harjeet S · Bakersfield, CAFirst renewal noticeN414TNKellum Roman Micah · Alexander City, ALN414TSPorter John W · Center, TXN414TXKwb LLC · Dover, DEN414UMSouthwest Management Group Inc · Farmington, NMN414USJohnson Lawrence F · Anchorage, AKN414UTRoth Colin E · Anchorage, AKN414VA7210 Charlie LLC · Atlanta, GAN414VBBank Of Utah Trustee · Salt Lake City, UTN414VTSnellmeyer Aviation LLC · Murrieta, CAN414WOn Top Aviation LLC · North Las Vegas, NVN414WDDonaldson Ted M · Thatcher, AZN414WEN414we LLC · Valrico, FLN414WMChristiansen Aviation LLC · Wilmington, DEN414WRMoreno Leon Bernardo Eucario · Missouri City, TXN414WSWessex Airlines LLC · Boca Raton, FLN414WTMr Boo Properties LLC · Indianapolis, INN414WWWillmott Webb B · Jackson, MSN414XMaag Wilford Darcy · Caldwell, IDN414XTHemet Mesa Aviation LLC · Dover, DEN414XXMcnally Operations LLC · Norfolk, NEN414YHVictory Maximus II LLC · Dublin, OHN414ZHynes Kevin P · Branson, MON41500Brandt Benjamin C · Nampa, IDN41502Skymates Inc · Wilmington, DE
Back to AD 2007-04-19 R1