AD 75-23-07
Registered aircraft · 827
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-23-07')
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-23-07')
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-23-07') 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-23-07') 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.
N3465GGv Air Inc · Medford, ORN3471GPage Garrett A · Rhodes, MIN3472GLosko Patrick J · Tustin, CAN3473GThayer John P · Columbus, GAN34WEWildes Thomas O · Chippewa Falls, WIN350CHFly Bye LLC · Georgetown, DEN350JCWear On Earth Aviation LLC · Potsdam, NYN350SDAmerican Aircraft Sales LLC · Lincolnshire, ILN3517GGv Air Inc · Medford, ORN3522GJ.A. White & Son Aviation LLC · Powder Springs, GAN3556GBenard Richard D · Lakeville, MAN355SCSmith Loren D · Great Falls, MTN3563GSkaya Aircraft LLC · Kalispell, MTN3587GAtor Robert W · Beach City, TXN358MNKeystone Aerial Surveys Inc · Philadelphia, PAN363RMMash Kity J LLC · Grand Rapids, MIN3640GTailwind Flight Center - Sue LLC · Sturgeon Bay, WIN364NYMarc Inc · Bolton, MSN367ATL&R Aircrafts Corp · Boynton Beach, FLN36846Armbruster LLC · Amherst, OHN36862Linville Keith · Bend, ORN3696GTfa Holding Corp · Daytona Beach, FLN36EWSalzer Dustin J · Weatherford, TXN36KWEastern Aviation Publishing Inc · Center Harbor, NHN3705GSouthern Illinois University DBA · Murphysboro, ILN3720GPersonal Space Aviation LLC · Nokomis, FLN37237Hudson Bay Holdings LLC · Lebanon, TNN37242Sol Aerial Surveys LLC · Las Vegas, NVN37256Patriot Air Inc · Belleville, ILN37268H & S Aircraft LLC · Lewes, DEN372CCLemieux Kenneth G · Oneida, TNN372FCHeartland Aviation Inc · Alliance, NEN372NMShelter Michael R · Sandy Lake, PAN3731GMaxwell Truck & Equipment LLC · State College, PAN3744GValiair Limited Co Trustee · Casper, WYN374TAVintage Aero Inc · Brandon, FLN377CEMetal Mistress Aviation LLC · Meadowview, VAN3796GSantos Aviation LLC · Chico, CAN3813GOne Three Golf LLC · Cleghorn, IAN3828GChoice Aviation LLC · Hamilton, MTN3835CPreferred Airparts LLC · Apple Creek, OHN3844CMansfield Heliflight Inc · Milton, VTN3995AMccoy Keith · Salt Rock, WVN3999SViking Aviation LLC · Kindred, NDN39BTMidwest Aerial Photography · Galloway, OHN3TQAbove Blue Line LLC · Austin, TXN3VJMiasnikowicz Victor · Lancaster, PAN400DPLindsey Russell R · Abilene, TXN400GMN400gm LLC · Salisbury, MDN400WMBryan Craig · Ellisville, MS
Back to AD 75-23-07