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.
N587DGLsm Aviation LLC · Rome, GAN588CTLynn Johnny Wayne · Indian Trail, NCN588SRSojo Air LLC · Abilene, TXN589CTNorton Vickie R · Huntington Beach, CAN589RCSkyflite LLC · Hillsboro, ORN589SRBe Happy LLC · Nashua, NHN58ACAlto Cirrus LLC · Coral Gables, FLN5907Summit Aviation Group LLC · Monument, CON590CDInternational Air Services Inc Trustee · Carson City, NVN591CDac-2020 Inc · Skaneateles, NYN591SCSrc22 LLC · Costa Mesa, CAN591WATv Trucks LLC · Eufaula, ALN592TGCirrus Design Corp · Duluth, MNN593GREji Services LLC · Cairo, GAN593MCChaffin Mark Bernard · Massillon, OHN593MRCirrus Design Corp · Duluth, MNN593MWWalsh Michael E · Cabot, PAN5953Air Traders LLC · Fayetteville, ARN595ASCowan Andrew T · Lucas, TXN595CDRhodes Matthew P · Indianapolis, INN595JMSkedaddle Air Corp · Lincoln, MAN595MWJta Aviation LLC · Lafayette, LAN595SRK C Cirrus LLC · Harrisburg, PAN595TVGephart Dan R · West Lafayette, INN595WPWhiskey Papa LLC · Baton Rouge, LAN596ACM&L Properties Of Alexandria LLC · Alexandria, LAN596CDBlue Developments LLC · Wilmington, DEN596CPFog Crow LLC · Austin, TXN596SRJ & J Flyers LLC · Jaffrey, NHN596WSCarevest Aviation LLC · Gloucester, MAN597CDGarnreiter Michael Trustee · Silverado, CAN597SRLowry Flying Service Inc · Grinnell, IAN598CDKabaet Aviation Charter LLC · Tarrytown, NYN598SRLowcountry Airborne LLC · St Helena Is, SCN599BCMilensky Chester D · Oviedo, FLN599MGN599mg LLC · Boulder, CON599MRPuder Craig Louis · Kansas City, MON599PMCirrus Maximus LLC · Pasadena, CAN59FESolomon Mark Trustee · Wilmington, DEN59JMCirrus Design Corp · Duluth, MNN59NHCirrus Design Corp · Duluth, MNN59PBPink Bubbles Air LLC · Marblehead, MAN59PXWaypoint Aviation Group LLC · Lenoir City, TNN59SBLearson LLC · Tarpon Springs, FLN5DSCirrus Flying Professionals LLC · Hollywood, FLN5KMB & B Aviation LLC · Vineyard, UTN5MKTysam Aero LLC · Graford, TXN5PVBlack Hills Aviation LLC · Saint Cloud, MNN5XNHuddart Martin · Farmington, CTN60034Jpb Holdings Inc · Kalispell, MT
Back to AD 2007-24-13