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.
N410RBAero Management LLC · Land O Lakes, FLN410RDVan Den Langenbergh Raymond · New Port Richey, FLN410RFFeldtman Robert W · Buckholts, TXN410RVVans Aircraft Inc · Aurora, ORN410RWButler National Inc · New Century, KSN410SAHanson Chad L · Hillsboro, NDN410SFKoehler Gregory S · Burlington, NCN410SJSutton Michael S · Arvada, CON410SLEngkvist Robert D · Esmond, NDN410T410t LLC · Kennett Square, PAN410TCNorth Star Aviation Inc · Mankato, MNN410TJWeselmann Brian D · Edgewater, FLN410TSShort Thomas M · Noblesville, INN410TTWerhan Alan · Rockford, WAN410TWRice Dwight L · Borger, TXN410TXSouthern Aircraft Consultancy Inc Trustee · Casper, WYN410VFour Ten Flyers LLC · Florissant, MON410WBHines Barrett D Trustee · Newbury Park, CAN410WDN410wd LLC · Dallas, TXN410WMFlying Life LLC · Middleburg, FLN410WPHamlin Andrew J · Two Rivers, AKN41108Winney Andrew J · Gothenburg, NEN4110HKoerkenmeier James J · Carlyle, ILN4110PSkyway LLC · Bronx, NYN4110XFoss Michael H · Niagara Falls, NYN4110ZJohnson Airspray Inc · Argyle, MNN4111JWarmuth Richard J · West Harrison, INN4111SKnowles Warren R · Ocean City, NJN4111YHousley Jaclyn R · Wasilla, AKN4111ZBredin Thomas W · Anchorage, AKN4112Feltmann Dean A · North Charleston, SCN4112HGroves Carl Jr · Lebanon, TNN41130Chapa Jana K · Corpus Christi, TXN41139Blair Mark Winston · Zachary, LAN4113EEllenburg Sixth Family Limited Partnership · Anchorage, AKN4113HWettstein Tim · Manhattan Beach, CAN4113JParnell Jerry L Jr · Panama City, FLN4113XDyer Dillon G · Clatskanie, ORN4113YKlintrin Collectibles LLC · Downers Grove, ILN4114Stauder Gregory P · Galena, ILN4114BGrove Mark T · Cave Creek, AZN4114JCrader Air LLC · Jackson, MON4114KNorth Florida Soaring Society Inc · Jacksonville, FLN4114SHeffernan Duane C · Moravia, NYN4114XDaniel William G Jr · Penhook, VAN4114YLight & Variable LLC · Arlington, VAN4115CHails Betsy B · Montgomery, ALN4115EBcs Properties LLC · Mead, CON4115HPeters Alan M · Arcola, TXN4115SDanielson Adam M · Chassell, MI
Back to AD 2007-04-19 R1