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.
N55260Weich Ronald L · El Paso, TXN55261Barton John S III · Gallatin, MON55263Fennell Donald H Jr · Hampstead, NCN55264Ace Aircraft Leasing Inc · Nazareth, PAN5526BDoelger Parker · Norwood, NYN5526FLandry Raymond L · Stark, NHN5526JBravo Leasing LLC · Daytona Beach, FLN5526KOn-Site Aviation Inc · Hillsboro, NDN5526MEz Breezy Fc LLC · San Diego, CAN5526PWard County Irrigation District #1 · Barstow, TXN5526UPearl Wings LLC · Doylestown, OHN55270Mcconnell Jason A · Rose Hill, VAN55272Nienhuis Alvin Dale II · Brooksville, FLN55273Jcb Aircraft Sales & Leasing Inc · Belle Mead, NJN55275Bas Part Sales LLC · Greeley, CON55278Hackman Daniel W · Wimauma, FLN55279West Georgia Air Services · Lagrange, GAN5527AMokiy LLC · Aurora, ORN5527BAdrenaline Inc · Chambersburg, PAN5527DCarns Ronald · Killeen, TXN5527FFarnie Christopher J · Jacksonville, FLN5527JBeachside Transports LLC · Hampstead, NCN5527SSilver State Aero Group LLC · Discovery Bay, CAN55284Winters Daniel K · Pennsburg, PAN55285Aerosim Academy Inc · Sanford, FLN55287Prairie Winds Aviation LLC · Overland Park, KSN55289May Richard J · Fallbrook, CAN5528KGates Steven S · Midlothian, TXN5528QCralle Family Aviation LLC · Midland, TXN5528RVroom Brian D · Tucson, AZN5528SCenturion N761lu LLC · Mukilteo, WAN5528VTrusler William L · Magnolia, TXN55291Riverside Flight Academy LLC · Riverside, CAN55292Aerosim Academy Inc · Sanford, FLN55294Heavy Metal Air LLC · Farmingdale, NYN55296Heavy Metal Air LLC · Farmingdale, NYN55297Goodhue LLC · Myrtle Beach, SCN55299Trego/Dugan Aviation Of Grand Island Inc · Grand Island, NEN5529DKanieski Maximilian M · New Canaan, CTN5529FKeiner Larry E · Drums, PAN5529JFarsighted Aviation LLC · Connersville, INN5529NTime 2 Fly LLC · Conroe, TXN5529QWhipple Ron · Etna, CAN5529SBreaking Wind Aviation LLC · Brainerd, MNN5529UStoll Travis · El Dorado Springs, MON5529VCandlestick Aviation Services LLC · Lewes, DEN5529WHarvey Gregory D Sr · Greenbush, MEN5529ZAerosim Academy Inc · Sanford, FLN552BWinkelbauer Kim G · Sun City, AZN552BBFrench Don Robles · Glendale, AZ
Back to AD 2007-04-19 R1