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.
N60WHSan Clemente David Paul · Edgewater, FLN60ZWGleitsmann Lars · Anchorage, AKN6100YRamsay Allan Trustee · Modesto, CAN6102WPlane Blessings LLC · Montrose, CON6103RAta Auto Service Inc · Wilmington, NCN6109RBas Part Sales LLC · Greeley, CON610KCU S Imaging Flight Ops LLC · Bartow, FLN6112ABarreto Manufacturing Inc · La Grande, ORN61170Rusty Pilot Holdings LLC · Citrus Heights, CAN6119ABrender Ronald F Trustee · West Lafayette, INN611CCTjc Productions LLC · Ogden, UTN611PGWrightson Properties LLC · Ft Lauderdale, FLN611WSFreedom Flight Service LLC · Glendale, AZN6126CM20k LLC · Minot, NDN6126YCruise Flight Aviation Inc · Denver, CON61275K & K Adventures Inc · Wilmington, DEN6128ROhop Robert D · Jones, OKN612CGCasa Grande Homes Inc · Blanchard, OKN612JRQ & A Company LLC · Newport, RIN612SFSky West Aviation Inc Trustee · Albuquerque, NMN612WPRobert A Johnson Construction Lc · High Springs, FLN6131AWigen Mary E · Porthill, IDN6131RAir LLC · Salem, ORN6131XGv Air Inc · Medford, ORN6134ECf Ranch & Cattle Co LLC · Burbank, OHN6139BFelker Gary L · Odessa, TXN6151QNitro Zeus Inc · Wilmington, DEN6151UMccall John A · Grapeland, TXN6151YBulloch Troy P · Cedar City, UTN6152BMohave County Board Of Supervisors · Kingman, AZN6153BCenturion Southeast Management LLC · Raleigh, NCN6155RPlane + Simple LLC · Salt Lake City, UTN6155YAl & Zal Corp · Wilmington, DEN6156QGem State Transportation Inc · Hamilton, MTN6159ULaw Office Of Vincent G Rieger · Kalispell, MTN615PCBurning Blue LLC · Greenwood, MSN615PJEngelstad Dana P · Midland, TXFirst renewal noticeN6161NOn Eagles Wings LLC · Los Gatos, CAN6161ZSkybound Holdings LLC · Orlando, FLN6162RSmjd LLC · Penrose, CON6167CSnyder Larry G · Holland, NYN6168NRegistered aircraftN616GROld Goat Aviation LLC · Chattanooga, TNN616RMMnemonics Inc · Melbourne, FLN6170NGarmin210 LLC · Willard, MON6173RBeyer Livestock Auction LLC · Clovis, NMN6174BN6174b LLC · Nokomis, FLN6176RJulius Kaleb · Mesa, CON6177XMayhew William D · Round Lake, ILN6178WBlu Sky Key West LLC · Key West, FL
Back to AD 75-09-13