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.
N594DSJsb Aviation LLC · Harrison, ARN594LCovington Stephen Ray · Longview, TXN594WSansone Law Aviation LLC · Saint Louis, MON5953Air Traders LLC · Fayetteville, ARN595ASCowan Andrew T · Lucas, TXN595CDRhodes Matthew P · Indianapolis, INN595DDStewart Aviation LLC · Phoenix, AZN595DLDcgc LLC · Gallatin, TNN595JMSkedaddle Air Corp · Lincoln, MAN595KR595kr LLC · Windermere, FLN595LTN595lt LLC · Edwards, CON595MWJta Aviation LLC · Lafayette, LAN595RWCarlgren Jenson E F · Santa Fe, NMN595SRK C Cirrus LLC · Harrisburg, PAN595TVGephart Dan R · West Lafayette, INN595WPWhiskey Papa LLC · Baton Rouge, LAN595XXHolladay Logan · Salt Lake City, UTFirst renewal noticeN596ACM&L Properties Of Alexandria LLC · Alexandria, LAN596CCFlorida Keys Diagnostic Center LLC · Key Largo, FLN596CDBlue Developments LLC · Wilmington, DEN596CPFog Crow LLC · Austin, TXN596RTRoeder Telfeian Air LLC · Cream Ridge, NJN596SRJ & J Flyers LLC · Jaffrey, NHN596WSCarevest Aviation LLC · Gloucester, MAN597CDGarnreiter Michael Trustee · Silverado, CAN597LAManta Holdings LLC · Winnsboro, SCN597LPMiller Richard · Stowe, VTN597SRLowry Flying Service Inc · Grinnell, IAN597THTlh Air LLC · New Castle, DEN598ASAssociated Auction & Liquidation Co · Clarksburg, TNN598CDKabaet Aviation Charter LLC · Tarrytown, NYN598DMAirswiss Inc · Wilmington, DEN598SRLowcountry Airborne LLC · St Helena Is, SCN599BCMilensky Chester D · Oviedo, FLN599MGN599mg LLC · Boulder, CON599MMCirrus Design Corp · Duluth, MNN599MRPuder Craig Louis · Kansas City, MON599PMCirrus Maximus LLC · Pasadena, CAN599SGCharlie Girl Aviation LLC · Mazomanie, WIN59ABates Roger · Palm Beach Gardens, FLN59CRUsvcausby LLC · Dover, DEN59EMFletcher Marvin L · Fargo, NDN59FESolomon Mark Trustee · Wilmington, DEN59FMCallison Rodney J · Tucson, AZN59HS59 Hotel Sierra LLC · Granbury, TXN59JMCirrus Design Corp · Duluth, MNN59KJSpike LLC · Cheyenne, WYN59MMPlane Fun Inc Tr Trustee · Snellville, GAN59NHCirrus Design Corp · Duluth, MNN59PBPink Bubbles Air LLC · Marblehead, MA
Back to AD 2012-10-13