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.
N4922HOptic Air LLC · Maurice, IAN4922JOpat Randall J · Port Saint Lucie, FLN4922LSpanjer William H · Pine Bush, NYN4922SNyrhinen Aki · Reno, NVN4922TShamseldin Nathan · Buckley, WAN4922VHhd Aviation LLC · Hamilton, OHN4922YHowey Aviation LLC · Woodhaven, MIN49236Lakeland Aero Club Inc · Lakeland, FLN49237Arnold J T · Sevierville, TNN4923ADaniel Arthur D · Fishtail, MTN4923CSmith Justin K · Wasilla, AKN4923DHarrier Aviation LLC · South Saint Paul, MNN4923LDevrnja Aero LLC · Louisville, TNN4923YDenton Aerial Spraying Inc · Las Animas, CON4924AMachnik Todd J · Old Lyme, CTN4924DRobinson Anthony D · Brookshire, TXN4924ENorthstar E & C LLC · Anchorage, AKN4924JCarper Clyde S · New Port Richey, FLN4924UScheren Raymond D · Johnson, VTN4925CRichardson Richard E II · Windham, MEN4925FA S Air LLC · Lantana, FLN4925GSchwenker David W · Queensbury, NYN4925KAlberts Nelson · Weatherford, TXN4925QEsty Effew LLC · Wimberley, TXN4926AEngland John James · Montrose, CON4926LRedden John V · Mooresville, NCN4926YDenton Aerial Spraying Inc · Las Animas, CON4927AGenx Aviation LLC · Leesburg, VAN4927CRegistration Pending · Helena, MTRegistration pending, pending cancellationN4927DGreenville Flight LLC · Greer, SCN4927LProfessional Plastic Solutions LLC · Irving, TXN4927NRmst LLC · Mason, OHN4927QWakefield Aircraft LLC · Cooperstown, NDN4927SDaniel L Voiers · Hephzibah, GAN4927UBetz Brett A · Reminderville, OHN4928EAce Of Spades Aviation LLC · Las Vegas, NVN4928LTwo8lima Llp · Bryan, OHN4928SJohnson Jeffrey S · El Dorado, CAN4928YSpragues Aerial Spraying Inc · Courtenay, NDN4929AApling Randall L · Wasilla, AKFirst renewal noticeN4929DUnion Flyers LLC · Union, SCN4929JBurnett Robert E · San Leandro, CAN4929LMaak Air LLC · Wahoo, NEN492ACRobinson Mark A · Carson City, NVN492BNTurner Harvey Jr · Raleigh, NCN492DSSkywest Leasing Inc · St George, UTN492FLMcknight Anna Mae · Vernon, TXN492JBBorke Michael F · Charleston, SCN492LGSunday Punchers LLC · Monrovia, INN492NDChristiansen Aviation LLC · Wilmington, DE
Back to AD 2007-04-19 R1