AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-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:2012-10-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:2012-10-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:2012-10-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.
N41HTJacobs Gregory R · Pinole, CAN41JGRegistration Pending · Farmingdale, NYRegistration pendingN41KBColne Valley Aviation Inc Trustee · Wilmington, DEN41KGSl Aviation Pro LLC · Tustin, CAN41LVGreataupair Holdings LLC · Austin, TXN41MMason Charles · Austin, TXN41NHHartz Norman E · Gardnerville, NVN41NRSholy Fred · Granada Hills, CAN41PJBank Of Utah Trustee · Salt Lake City, UTN41RPPittsburg Steel LLC · Pittsburg, TXN41SAIntegrated Design And Supply Inc · Crystal Lake, ILN41SMHarper & Co Builders Inc · Douglas, GAN41TTAlvis Michael Ernie · Sparta, TNN41VHSutherland Jason · Auburn, WAN41VRWalker Vincent Paul · Medford, ORN41VVTurner Andrew · Orange Beach, ALN41WTPremiere Aviation Inc · Concord, CAN41WVKmfg3 Aero LLC · Barrington, NHN41XPIra Ellis LLC · Jackson, TNN4201CFlying 4 LLC · Whiteville, TNN420BLN420bl LLC · Carmel, INN420GWSchell Scott A · Lisbon, NDN420HLJannelli Gilbert DBA · Clearwater, FLExpired dealerN420SDCottonport Air LLC · Marksville, LAN420SEVadola James J Jr · Hillsborough, NJN420SSZardoz Aviation Inc · Spring, TXN4216QFoulkrod Freebird LLC · Buda, TXN421AGone Flyin LLC · Wilmington, DEN421CShadow Cat Aviation LLC · Fitchburg, WIN421CBDegrado Aviation LLC · Sedalia, CON421CDTarsky Project LLC · Panama City Beach, FLN421NGcmj Air LLC · Naples, FLN421PWMead Lawrence C Trustee · Powell, OHN4228CBurhmann Joel David · Justin, TXN422AKAlpha Kilo One LLC · Humble, TXN422ATDec Flight Services LLC · Sandy Springs, GAN422BMBrister Aviation LLC · Amarillo, TXN422BSN422bs LLC · Bluffton, SCN422DRQualitair LLC · MichelstadtN422DSDs Aero Industries LLC · Fresno, CAN422EMLawn Shed LLC · Eau Claire, WIN422GH422gh Aviation LLC · Tampa, FLN422GKKierspe Leasing LLC · Aiken, SCN422JMVertical Consulting LLC · Boise, IDN422LDMld Services LLC · Atlantic Beach, FLN422LMJafari Dadbeh · Edmond, OKN422LTSr Flyers LLC · Baltimore, MDN422MMBolt Robert S · Tampa, FLN422PCSalty Pines LLC · Haverford, PAN422RJTopflight Aviation Inc · Brentwood, TN
Back to AD 2012-10-13