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.
N437SPN437sp LLC · Manassas, VAN437TChattin Robert C · Garden City, IDFirst renewal noticeN437WWoodward James W · Sagle, IDN437WTBenkert Levi James · Austin, TXN437WYDonohoue Maureen T Trustee · Lander, WYN437XCoray Oliver J · Soldotna, AKFirst renewal noticeN43801Schnoor Max M Jr · Cambridge, MDN43802Armstrong David · North Pole, AKN43806Heard Jesse H · Lewiston, IDN43808Cherokee Flying Club Inc · E Longmeadow, MAN4380DLivengood Leasing Co LLC · Mesa, AZN4380LSkelton Cattle Co LLC · Osceola, NEN4380S9791m LLC · Tacoma, WAN4380WAtaraxia Aircraft Holdings LLC · Greenville, SCN4380XEasterly Land And Cattle Inc · Sidney, NEN4380ZMike Harmon Aviation LLC · Mansfield, SDN43810Lain Snow LLC · Ocean Isle Beach, NCN43812Schiffer Todd · Franklin, PAN43813Gq Aviation LLC · Cherry Hill, NJN43817Fraser Roger Douglas · Amelia Island, FLN4381AN4381a Inc · Shoreview, MNN4381JPugh Robert Randall · Brewton, ALN4381LAir-Mods Flight Academy Inc · Robbinsville, NJN4381PChase 13 LLC · Wilmington, DEN4381QAero Wise Services LLC · Decatur, TXN4381RDugan James M · North Bend, OHN4381SPilatus Aircraft USA Ltd · Broomfield, CON4382JGood Flight Aviation LLC · Stockton, CAN4382QLegends Air LLC · Wilmington, DEN4382RMoranski Joseph F · Budd Lake, NJN4382TGray Robert C · Dalton, MNN4382XN4382x LLC · Tewksbury, MAN4382ZFlerlage Katy Anne · Maple Hill, KSN43836Robinson Marissa · Burgettstown, PAN43839Legacy Aviation LLC · Sullivan, INN4383FRed Tail Scholarship Foundation · Tuskegee, ALN4383PBeard Michael L · Marble Hill, MON4383QBladen Aviation Inc · Elizabethtown, NCN4383ZBredthauer Glen E · Hastings, NEN43843Koenig David J · Crosslake, MNN4384AJourneys Aviation Inc · Boulder, CON4384CWooliver Stephen P · Wasilla, AKN4384FEes LLC · Thomaston, CTN4384JBennett Nicholas C · England, ARN4384KLewis Flying Service Inc · Morse, LAN4384QMorten John E · Larimore, NDN4384RAmerican Patrols Inc · Midland, TXN4384TTaw Development Inc · Raleigh, NCN4384WPacific Media Properties Inc · Santa Ana, CAN4384ZSilent Knights Inc · Ankeny, IAFirst renewal notice
Back to AD 2007-04-19 R1