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.
N734CDJds Aviation LLC · San Mateo, CAN736CPSpivak Maxim Trustee · San Jose, CAN736SRGlobal Horizon Investments LLC · Flower Mound, TXN736WFWarner Chad · Gualala, CAN73ARStay In Your Plane LLC · Austin, TXN73BPRealty Trust LLC · Southbridge, MAN73CCBoomer4 Aviation LLC · Cincinnati, OHN73JQZam Air LLC · Wilmington, DEN73WESchroeder Andrew R · Hoover, ALN73WFSky Park Drive LLC · Custer, SDN73WKCapital Holdings 251 LLC · Newark, DEN73WTBa Cane Aviation LLC · Weston, FLN740CD429 Aviation LLC · Dallas, TXN740NGDodson International Parts Inc · Rantoul, KSN741SCKaczorowski Michael T · Reisterstown, MDN742CCCirrus Design Corp · Duluth, MNN742DDPlane Fun Inc Tr Trustee · Snellville, GAN742JHWatson David P · Pottsboro, TXN742LCN742lc LLC · Maryville, TNN742LGGln Executive Aviation LLC · Powell, OHN742SCMissouri First Aviation Inc · Lebanon, MON743CDHerrington James C Jr · Mullins, SCN743GMDym Flights LLC · Pembroke Pines, FLN743NXVolare III LLC · Harlingen, TXN744CDCirrus Drivers Zoom LLC · Folsom, CAN744MSSierra Foothill Properties LLC · Auburn, CAN744SMDodson International Parts Inc · Rantoul, KSN744TCGottesman David · Petaluma, CAN745ARLlv Aviation LLC · Naples, FLN745CDTrujillo Dax K · Show Low, AZN745NBT & H Ahrens LLC · Nevada City, CAN746ABCitation Point Leasing LLC · Naples, FLN746CBr Aviation LLC · Bellevue, WAN746CDSky West Aviation Inc Trustee · Albuquerque, NMN746JAInternational Air Services Inc Trustee · Carson City, NVN746SRGossett John · Bellbrook, OHN7478Hubbard Matthew L · Phoenix, AZN747ASRooks Peter L · Andover, MAN747CTN747ct LLC · Mayfield, KYN747LJEichleay Peter · Yarmouth, MEN747LLSouthern Aircraft Consultancy Inc Trustee · Casper, WYN747MBMaitland Egerton M Jr Dr · Lexington, SCN747PJOsprey Capital LLC · Winston Salem, NCN747PLSouthern Aircraft Consultancy Inc Trustee · Casper, WYN747SDAvitrans Inc · Cypress, CAN747SJBuell Steven M · Fisherville, KYN747SWJet Air Inc · Iowa City, IAN747TGValiair Ltd Co Trustee · Casper, WYN747TTDogbolter Aviation LLC · Milwaukee, WIN748CDPinkgg LLC · Marathon, FL
Back to AD 2007-24-13