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.
N269NEOro LLC · Tilden, NEN269PBHmw LLC · La Grange, NCN269PCSch Aviation Inc Trustee · SporleN269R219 Air LLC · South Bend, INN269RAFuller Aire Inc · Wilmington, DEN269RHUnterreiner Dean · Prince George, VAN269RTTodd Jon R · Georgetown, CAN269RVHershey Lester E · Amelia Court House, VAN269SFlightco Inc · Swainsboro, GAN269SAAlthof Equipment Management LLC · Jupiter, FLN269SFHarvey Kandace · Snohomish, WAN269STSalina Tree Inc · Salina, KSN269TCRegistration Pending · Redmond, WARegistration pending, pending cancellationN269TJSenninger Thomas P · Clermont, FLN269TUAero Quest LLC · Olive Branch, MSN269VCRegistered aircraftN269WFThomas Wilmer C · Fairbanks, AKN269WMRenninger Log Homes · Meeker, CON269WTWillis James A · South Jordan, UTN269YEyles Richard L · Galloway, OHN269YADavenport Ross K · Raleigh, NCN26AAMustang Sally Aviation LLC · Camden, SCN26ADTango Aviation LLC · Valrico, FLN26AESwallows Inc · San Jose, CAN26AJByford Christopher H · Mc Gregor, TXN26AKLousberg Daniel A · Wasilla, AKN26AUMaximum Entropy Inc · Wilmington, DEN26AWAntique Aircraft And Automobile LLC · Van Alstyne, TXN26AYR44 White LLC · Kalispell, MTN26BMRegistered aircraftN26BQAb Prop Plane II LLC · Metairie, LAN26BRStender Aviation B LLC · Huntsville, ALN26BWBestul Greg · Lester Prairie, MNN26BXPeak Performance Helicopters LLC · Dover, DEN26BYSnohoacro LLC · Mukilteo, WAN26CFKustatan Leasing LLC · Nikiski, AKN26CLPuckett Lewis R · Ellijay, GAN26CMLaurel Highlands Aeronautical Academy · Latrobe, PAN26CRSim International Inc · Fort Mill, SCN26CSJetswiss LLC · Overland Park, KSN26CUAnselmo Jeffery A · Fairfield, CAN26CWBarzelatto Brett · Thornton, CON26CXCiholas Philippe A · Sedgwick, KSN26DASimons Thomas A · Howes, SDN26DBDen Besten Dale L · Canton, SDN26DCAce Aviation LLC · Reading, VTN26DEContinental Title Trust LLC Trustee · Wichita, KSN26DHZurinsky Richard · Port Orchard, WAN26DLHayden David Bernard Trustee · Roach, MON26DSSimorgh LLC · Omaha, NE
Back to AD 2007-04-19 R1