AD 2007-24-13
Registered aircraft · 4,026
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-24-13')
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-24-13')
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-24-13') 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-24-13') 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.
N415PJPalm Springs Air Museum · Palm Springs, CAN415PW415air LLC · Tiburon, CAN415TLEilts Jason · Jefferson, GAN415WBCanon Robert G · Waller, TXN416CDLewis Jim C · Tigard, ORN416CERedwing Aviation LLC · Largo, FLN416GWidhalm Chelsea · Yakima, WAN416PCKjt Aviation LLC · Beaumont, TXN416RJCirrus Design Corp · Duluth, MNN416SCribbie Ronald J Trustee · Hernando, FLN416TDC C Aviation Group LLC · Wilmington, DEN416WBSoaring Eagle Air LLC · Salt Lake City, UTN417JRBinary Ninjutsu LLC · Myrtle Beach, SCN417JTQuick Kenneth Wayne · Cordova, TNN417KHWillens Mark D · Livermore, CAN417LCFowm LLC · West Memphis, ARN417MMN417mm LLC · Kirkwood, MON417PWFleur De Lis Krewe LLC · Orlando, FLN417TABrickler Alexander J · Tallahassee, FLN417WDWheels Down LLC · Oklahoma City, OKN418BCFlying Beep LLC · Athens, GAN418JCWalker Richard A · Omaha, NEN418MLLloyd Morty C · Apison, TNN418RMWind Sock Aviation LLC · Lancaster, KYN419CDRsk Aviation LLC · Midland, MIN419STMyers Steven L · Goodyear, AZN41CASale Reported · Trapper C Reek, AKSale reportedN41DWOne Delta Whiskey LLC · Westport, CTN41JGRegistration Pending · Farmingdale, NYRegistration pendingN41KBColne Valley Aviation Inc Trustee · Wilmington, DEN41MMason Charles · Austin, TXN41PJBank Of Utah Trustee · Salt Lake City, UTN41SAIntegrated Design And Supply Inc · Crystal Lake, ILN41SMHarper & Co Builders Inc · Douglas, GAN41VVTurner Andrew · Orange Beach, ALN41WVKmfg3 Aero LLC · Barrington, NHN41XPIra Ellis LLC · Jackson, TNN420BLN420bl LLC · Carmel, INN420GWSchell Scott A · Lisbon, NDN420SEVadola James J Jr · Hillsborough, NJN420SSZardoz Aviation Inc · Spring, TXN421CShadow Cat Aviation LLC · Fitchburg, WIN421CDTarsky Project LLC · Panama City Beach, FLN422AKAlpha Kilo One LLC · Humble, TXN422BSN422bs LLC · Bluffton, SCN422DRQualitair LLC · MichelstadtN422GH422gh Aviation LLC · Tampa, FLN422GKKierspe Leasing LLC · Aiken, SCN422JMVertical Consulting LLC · Boise, IDN422LDMld Services LLC · Atlantic Beach, FL
Back to AD 2007-24-13