AD 75-09-13
Registered aircraft · 4,787
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:75-09-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:75-09-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:75-09-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:75-09-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.
N464DCDelta Charlie Aviation LLC · Glendale, AZN4653Q53 Quebec LLC · El Dorado, CAN4656KValley Agriculture LLC · Galt, CAN465DLKeystone Aerial Surveys Inc · Philadelphia, PAN4660JStuder Al C · Shelby, MIN4665CKrissman Ryan · Gallup, NMN4666NM & P Genpar LLC · Corpus Christi, TXN4668NSre Holdings LLC · Dewitt, MIFirst renewal noticeN466CAHyannis Air Service Inc DBA · Hyannis, MAN466PJv Aviation LLC · Johnston, RIN4671KNifong Robert B · Jacksonville, FLN4672KMartin Richard E Trustee · Colorado Springs, CON4674NBorderline Sky LLC · El Paso, TXN4674UKlein David · Sebastopol, CAN4677NLps Equipment And Acquisition Co Inc · Clarksburg, TNN4678QPrairie Dog Aviation LLC · Sioux Falls, SDN4679YExtreme Air LLC · Cottage Grove, WIN467DBParamont Services Inc · Newbury Park, CAN467DMMustang Sally Aviation LLC · Camden, SCN467PZAirline Training Professionals LLC · Wilmington, DEN4680NRentz Communications Inc · New Smyrna Beach, FLN4682QHangar 27 LLC · Bountiful, UTN4690UKim Hansen Co · Burley, IDN4694YKempton Chevrolet Buick Ltd · Safford, AZN4694ZKyro Consulting LLC · Williamsburg, VAN4695AAgarwal Ravi · Bath, PAN469HPTrussell David · Fremont, CAN46CRBas Part Sales LLC · Greeley, CON46CSPlane Fun Inc Tr Trustee · Snellville, GAN46EHStar H Aviation LLC · Plano, TXN46LAMagoon Paul J · Merrimack, NHN46MGHughes Shaun · Everett, WAN46MRDavin Matthew · Ridgecrest, CAN46PAAyer William S · Bellevue, WAN46PCMace Robert C Jr · Gold Canyon, AZN4701AWtfa LLC · Decatur, ALN470BCCorvus Flight LLC · Salinas, CAN4712KMclellan Bruce A Trustee · Bend, ORN4714CGorman Aviation LLC · Bartlesville, OKN4715WKelley Christopher L · La Quinta, CAN4716XJessup Sheila · Dublin, CAN4717CCt Aviation LLC · Fort Worth, TXN471HBMyers Ralph E · San Clemente, CAN471MASwift Aviation LLC · Decatur, TNN4720CNesbit Gary M · West Linn, ORN4720PKlingler Larry R · Wolfeboro, NHN4720YKraemair Aviation LLC · Sauk City, WIN4722FStoskopf Scott W · El Dorado, KSN4723YRegina Air Cargo Corp · Wilmington, DENon-citizen corporation, flight hours not reportedN4726YMeisner David B · Meridian, ID
Back to AD 75-09-13