AD 72-17-01
Registered aircraft · 172
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:72-17-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-17-01')
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:72-17-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-17-01') 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.
N26RDPacific North Air LLC · Portland, ORN277AMParis Air Inc · Vero Beach, FLN2824TEscudier Henry · Houston, TXN2871TCloud Dancer Aviation Inc · Deland, FLN2882TParis Air Inc · Vero Beach, FLN28BMUS Flight Academy Intl Inc DBA · Post, TXN300DESchmidt Arthur J · Tampa, FLN302EFRedbird Ventures LLC · Kalispell, MTN303RCYogini Modi · Homestead, FLN3097TD & L Aircraft Leasing LLC · Ormond Beach, FLN30FHBaldwin Jonathan B · East Boothbay, MEN333BBDenecke Robert W · Fredericksburg, VAN333SEParis Air Inc · Vero Beach, FLN341TCRegistration Pending · Wilmington, DERegistration pendingN34201Talon Air LLC · Newport, KYN342GRSouthern Aero LLC · Homestead, FLN344MCEuroaviation Inc · KematenN34ESTough Old Bird Aviation LLC · Beavercreek, OHN34MYParis Air Inc · Vero Beach, FLN37SACampbell John R Trustee · Saint Leo, FLN401DSDelaware State University · Dover, DEN4063GHorizon Flights Corp · Henderson, NVNon-citizen corporation, flight hours not reportedN40785Plane Fun Inc Tr Trustee · Snellville, GAN40982Seneca Aviation LLC · Wheaton, MDN411SVCc Aviation Inc · Tracy, CAN41249Sale Reported · Nephi, UTSale reportedN41285Paris Air Inc · Vero Beach, FLN41502Skymates Inc · Wilmington, DEN41538Sunrise Aviation Inc · Ormond Beach, FLN41960Tiffin Aviation Services Inc · Nogales, AZN424WTLumberton Air 1 LLC · Mount Laurel, NJN428663 Elm Terrace LLC · Waterville, MEN43034A S Flight Academy LLC · Lantana, FLN43130University Of Maryland Eastern Shore · Princess Anne, MDN43134Minot Aero Center · Minot, NDN43394Skyline Solutions Inc · Deland, FLN43519Paris Air Inc · Vero Beach, FLN43577Novaair LLC · Lake Sherwood, CAN43690Fly Twin Commanche LLC · Peoria, AZN439PTKnot Mach LLC · Mchenry, ILN44332International Air Services Inc Trustee · Carson City, NVN44416Registration Pending · Punta Gorda, FLRegistration pendingN444SAPhoenix East Aviation LLC · Daytona Beach, FLN4475TWings Over Texas Holdings LLC · Denton, TXN4481TValdes Eusebio · Miami, FLN4534TSunrise Aviation Inc · Ormond Beach, FLN4542TFlight Leasing Corp · Wilmington, DEN455LPhoenix East Aviation LLC · Daytona Beach, FLN4567TPhoenix East Aviation LLC · Daytona Beach, FLN4574TBas Part Sales LLC · Greeley, CO
Back to AD 72-17-01