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.
N291ABSerafini Louis · Ringwood, NJN2921BMurray Michael E · Fallbrook, CAN2980AWest David R · Newalla, OKN29DCDwlg Aviation LLC · Rogers, ARN29VRegistered aircraftN2CBBoxman LLC · Wilmington, DEN2CSBolton Geoffrey M · Groveland, CAN2DCGottsleben John J · Tucson, AZN2DNHaines Matthew E · Lake Dallas, TXN2DURegistered aircraftN2EYBender Jeffrey T · Scottsdale, AZN2JXBrookeash Inc · Waxahachie, TXN300ABDelaware Aircraft Trust LLC Trustee · New Castle, DEN300CLHustak Michael G · Granbury, TXN3017WKirk Michael E · Alvin, TXN3023WBoughen James R · Camas, WAN3032WDebrouwer Isabelle Mc · Alpine, TXN303LWHoward Dan E · Hurricane, UTN3041CVangundy Timothy S · Camby, INN3041WEstes Aviation LLC · Rapid City, SDN3051AHigby James E Jr · Frederick, CON3057WBaskins Robert H · Huntington Beach, CAN3064WDavid And Shirley Houchin LLC · Crescent City, FLN3092WPrimm Daniel D Jr · Lexington, KYN3099WSavage Curtis Mac · Johnstown, OHN309DCRother Michael V · Granbury, TXN30EDN30ed LLC · Carpinteria, CAN30VTPlane Fun Inc Tr (Trustee) · Snellville, GAN3102WBonanza Leasing LLC · Versailles, KYN3111WChubb Oil & Gas LLC · Missoula, MTN311BGBluffton Flying Service Ltd · Bluffton, OHN3128WSterling Anthony K · Wilson, NCN3135WFlycarolina LLC · Concord, NCN3138WN3138w Bonanza V35b LLC · Jeffersonville, INN313DBHelm Walter · Sacramento, CAN313WWilliams Thomas James · Clovis, CAN3147WTadesco Rothchild LLC · Wilmington, DEN315ABColabianchi Bob J · Fountain Hills, AZN3161WPritchard Casey M · Bells, TXN3163WSkye Peak Corp · Greenfield, MAN317CHCrestair Air LLC · Dover, DEN317EPMcelligott Michael J · Woodstock, VAN317SCDuehring Jonathan H · Raleigh, NCN317SWMcnaughton Aviation LLC · Bondurant, IAN3180WPepe Charles · Morrisville, VTN3181WNormark Jordan C · Granbury, TXN3194CNortje Bryan John · Gold Hill, NCN319RFFairfax Ronald E · Hailey, IDN31FSStrickland Corp · Onida, SDN3206LAlpha Tango LLC · Omaha, NE
Back to AD 75-01-07