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.
N345URegistered aircraftN345UHUhi Inc · Provo, UTN345USAvion Solutions Group LLC · Apex, NCN345WAWiseman Aviation Inc · Flagstaff, AZN345WFMullens Gregory · Spencer, OKN345WGMajors William B · Glen Carbon, ILN345WHEaves Glenn Ellsworth Jr · Rocky Ridge, MDN345WWOtter Mark E · Warrensburg, MON345YParagon Airplane Leasing Co · Fort Myers, FLN345ZMetz Howard L · Los Angeles, CAN346Mclendon Kennon A · Fortson, GAN34602Hopkins Peter Matthew · Vancouver, WAN34604Mccosh John · Piedmont, OKN34606Coulter Lance A · Meeker, CON3460FCut And Snip Flyers LLC · South Weber, UTN3460LFaulkner Jeannine P · Bethel, AKN3460RHenninger Mark E · Mill Creek, WAN3460TBrowning Sean · Anchorage, AKN3460WCarruth John T · Danvers, MNN3460XKallner Carl Magnus · Jackson, NJN3460YLeng Jeffrey E · Buckley, WAN3461Vizachero Albert · Spring Lake, NCN34612Hummel Frank E · Everett, WAN34614Samreth Sokham · Lorton, VAN34616Gois Paul · Westfield, MAN3461NBrown Hugh · Lubbock, TXN3461SBoyle Gene J · Moab, UTN3461WBplj LLC · Old Monroe, MON3461XPerez Carlos D · Horizon City, TXN34620Patton Gilbert L · Merritt Island, FLN3462309y Flying Club · South Saint Paul, MNN34626Ross Amy · Los Alamos, NMN34629Gradus Magnam LLC · Ocracoke, NCN3462ENc86 Flying Club Inc · Mooresville, NCN3462FBehrendt Matthew D · Winsted, CTN3462LFuss Douglas A · Fort Worth, TXN3462RFor Skies Flying Club Ltd · Martinsville, ILN3462TJunck Kyle D · Branson, MON3462XNewberry Alfred L · Harrison, ARN3462ZWilson Anthony J · Bartlett, TNN34631Norton David Thompson · Dallas, TXN34634Patterson Kathleen M · Marlborough, MAN34636Ubi Aviation LLC · Palm Harbor, FLN3463FLee Paula S · Sandpoint, IDN3463GBuckles Robert F · Boseman, MTN3463NN83993 LLC · Cherry Hill, NJFirst renewal noticeN3463UYancey Cameron L · Anchorage, AKN3463YMartin Michael · Anchorage, AKN3463ZJordan Dalton · Pataskala, OHN34644Juliette Aviation LLC · Allen, TX
Back to AD 2007-04-19 R1