AD 75-01-07
Registered aircraft · 2,118
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-01-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-01-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-01-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-01-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.
N4847JLittle River Corp · Anchorage, AKN4850JCardamone Rayner Mark Gibson · Manistique, MIN4852JStoffel Christopher David · Colorado Springs, CON4853JNaca 130 LLC · Cameron Park, CAN4856JN4856j LLC · Boulder, CON4871JGray Robert R · Granbury, TXN4889JRegistered aircraftN488FDLittleton Darrell D · Atlanta, TXN4894JCapri Blue Aviation LLC · Norcross, GAN4896JMyshatyn Michael · Eaton, CON48KUWildcat Aviation LLC · Wilmington, DEN48LFKraxberger Scotty L · Salida, CON48MHSeventh North Hangar LLC · Bolton, MAN48RSColin A Oerton · Miami Beach, FLN4984MBas Part Sales LLC · Greeley, CON4989MRistevski Bill · Vacaville, CAN499DSDelta Sierra Aviation · Wilmington, DEN499MBCook Joshua D - Trustee · Nashville, TNN49PGVasiloff Mark · Barberton, OHN49TRVincent T Remcho Phd LLC · Corvallis, ORN4FHWall Jacob · Grapevine, TXN4HHAndrews Terry · Camp Verde, AZN4JXCosta James J · Tulare, CAN4WRShoemaker David J · Menlo Park, CAN4XPPazdziora Ronald G · St Charles, ILN500PFHumphries Stephen A · Kingwood, TXN506HPPedden Patrick M · Fort Wayne, INN5092NMill-Run LLC · Lewes, DEN509JMRegistered aircraftN50BDGoodrich Gilbert Joseph · Katy, TXN50JMMinter Michael D Jr Trustee · Rock Port, MON50ZTackes Steven · Carson City, NVN510CHTj Air Holdings Inc Trustee · Wilmington, DEN512BDTurbo Aviation LLC · Chesterfield, SCN514CSTomco Stores Ltd · Ruidoso, NMN514PCParsons Donald E · Clarksville, TNN516WClearwater Holding LLC · Parkersburg, WVN517KGRegistration Pending · Pittsburg, TXRegistration pendingN518MMull Jason E · Chester, NYN51HMDw Peterson Inc · Warren, MNN521VRMyers Jonathan A · Dieterich, ILN523QNixon John H · Ormond Beach, FLN523TCSmith Ranch Bonanza LLC · San Francisco, CAN523ZARegistration Pending · Perryton, TXRegistration pendingN525BHWalker Craig · Pleasant View, TNN529DDSchwertfeger Dean · Woodruff, WIN52AUUllman Aaron L · Barksdale Afb, LAN530CContinental Title Trust LLC Trustee · Wichita, KSN531BFLouis F Olberding Dds Pc · Lincoln, NEN533SZilz Tammy S · Saint Peters, MO
Back to AD 75-01-07