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.
N52175Sale Reported · Bangor, MESale reported, pending cancellationN5217CHydro Wings Inc · Valle Crucis, NCN5217DOptima Aviation LLC DBA · Lewisville, TXN5217ERamsey Thomas R · West Bath, MEN5217HB&R Aircraft LLC · Wadsworth, OHN5217LKenny Tommy D · Maryville, MON5217PLevezow Steven M · Manawa, WIN5217TJahangiri Ali · Arlington, TXN5217UKelly Colby R · Anchorage, AKN5217VScrobola Air LLC · Wyoming, PAN5217WS B Enterprise LLC · Marshall, TXN52187Monk Robert William · Lake Tomahawk, WIN52188De Aviation Inc · La Porte, TXN5218ETopsail Beach Aviation LLC · Topsail Beach, NCN5218FMacmillan Performance LLC · Torrance, CAN5218GMarlowe James D · Genoa, OHN5218LTjossem James · Thompsons Station, TNN5218NMorin Shawn D · Franklin, TNN5218QRoberson J R · Mabank, TXN5218YMcintire Aviation LLC · Middletown, DEN52197Hodges Ray L · Wasilla, AKN52199Registered aircraftN5219JUpham David E · Madison, WIN5219LShanley William D · Orland Park, ILN5219NA Cloud Above Aviation LLC · Spooner, WIN5219RCoston Mace C · Maryville, MON5219URuryk Jonathan D · Pineville, LAFirst renewal noticeN5219VSkymates Inc · Wilmington, DEN521ADBarringer Aviation LLC · Waxhaw, NCN521AFChhh LLC · Raleigh, NCN521AMDoll Joseph L · Lenoir, NCN521BSAtlas Aviation LLC · Marietta, GAN521BTBennett Brady R · Pinehurst, NCN521BWBilmar Avionics Inc · Kissimmee, FLN521CRuhan Brendon Thomas · Rehoboth, MAN521CAAftcloud Inc · Ontario, CAN521CBHodge Cleo U · St Thomas, VIN521CWCentral Washington Univ · Ellensburg, WAN521DBBowling Donald W · Greensburg, INN521DDUrbana Aviation LLC · Woodstock, OHN521DHPenner Ford Aviation LLC · Lebanon, MON521DMAllison James R · Middlefield, OHN521DPWin Holdings Inc · Englewood, CON521DZSchultz Charles J · Juneau, AKN521EAngels Ten LLC · Norfolk, VAN521EPEpic Aviation Inc · New Smyrna Beach, FLN521ER521er LLC · Blaine, MNN521FCStevens Kole · Sebec, MEN521GHAirborne Helicopters LLC · Hendrum, MNN521GTNeptune Skies LLC · Little Elm, TX
Back to AD 2007-04-19 R1