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.
N17751Brewer Bret D · Woodward, OKN17797Nieman James Lewis Jr · Alhambra, CAN17814Sellers Scott · Solsberry, INN17816Legal Flying Service Inc · Pembroke Pines, FLN17827Cumins Douglas · Mechanicsville, VAN17840Es Investments LLC · Chandler, AZN17865Wcs Inc · Troy, ALN178QRega Consulting Inc · Port Orange, FLN17988Gonneville Donald E Jr · Durango, CON179KDTblc LLC · Princeton, NJN179RMyers Aviation Inc · Oshkosh, WIN17CBCygnet Aerospace Corp · Los Osos, CAN17CCReinhart Alan · Ventura, CAN17FECox Matthew B · Russiaville, INN17MABearden James D · West Point, MSN17PKSmith Kevin B · Camden, NCN17VMPayne Jerry L · Baton Rouge, LAN17WFDraper Russell E · Camarillo, CAN1803LNielsen James I · Waddell, AZN1803WCooper Properties Inc · Denver, CON1805LJacoby Peter A · Tucson, AZN1812LVintage Aviation LLC · Huntington, INN1815DOdell Ryan S · Yukon, OKN1815GGalaxy Aviation LLC · Nantucket, MAN181CBBuchanan Clayton W · Fernandina Beach, FLN181PJPeake Herschel S · Dallas, TXN1822NMars Michael Morrow · Collierville, TNN1822WLawrence Kevin M · Meridian, MSN1825LBonanza Flying Club LLC · Ogden, UTN18276Stack Ed · Prospect Heights, ILN18287Three Wings Aviation LLC · Kalispell, MTN18294Bundy Holdings LLC · Walnut Grove, MON182QWhitt Carson M · Deland, FLN18304Bean David Jay · Miami, TXN18307Wings Management LLC · Springville, UTN1830WSoyars Tom · San Marcos, TXN18315Gregory G William Jr · York, SCN18318Registration Pending · Fosters, ALRegistration pendingN18329Coggin Marilyn · Longview, TXN18331Fred Garrison Oil Co · Plainview, TXN18337Urban James G · Panama City, FLN1834WTri-Aero Of Grand Rapids · Ada, MIN18368Olaf LLC · Bellbrook, OHN18369Barmakian Bruce · San Bernardino, CAN1837LHornby Mark H · New Bern, NCN1837ZBert Aviation LLC · Clemmons, NCN183QDrajesk Jeffrey F · Fish Creek, WIN1840WPutz Aeroplanes LLC · Bryan, TXN1844LRao Enterprises LLC · Brighton, MIN18470Entwistle Charles W · Leicester, MA
Back to AD 75-01-07