AD 80-25-07 R1
Registered aircraft · 25,370
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:80-25-07-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
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:80-25-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') 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.
N5536QWokini Air LLC · Tarpon Springs, FLN55374American Patrols Inc · Midland, TXN5537CM G Aviation · Tyler, TXN5537HLine Michael · University Park, MDN5537KSales First LLC · Jasper, GAN5537RBalady Nabih · Santa Clarita, CAN5537SMcpeak Alan W · Colorado Springs, CON5538KHilowitz Andrew J · Anchorage, AKN5538QDurkee Brenton J · Brooklyn, NYN5538YTeton View Aircraft Leasing LLC · Grass Valley, CAN55398Three Wire LLC · Portland, ORN5539QJostad Leo D · Bottineau, NDN5539TPattison Aero Inc · Henderson, NVN553APAviation Paradise LLC · Homestead, FLN553SFSmith Nancy R · Duluth, MNN55404Atlanta Aviation Academy Inc · Lawrenceville, GAN55409Burrowes William A · Springfield, OHN5540KTymczyszyn William R · Torrance, CAN55420M A R S Aircraft Leasing LLC · Williamsburg, VAN55422Boardman Thomas M · Greenwich, NYN5543EMedina Kevin S · Glendale, CAN5543KClassic Aviation LLC · Richmond, MIN5544KZollars Thomas B · Dallas, TXN5544LRegistration Pending · Troy, NYRegistration pendingN5544SLobitz James R Co Trustee · Oak Park, CAN5544TPercario Joseph · Warren, NJN55457Legend Air Lease LLC · Hurricane, UTN5545KSchroder Bernd · Brownsville, CAN5545QVan Wagner Paul A · Waterford, PAN5545SLareve Air LLC · Bloomfield, MIN5545TMoody Bible Institute Of Chicago · Spokane, WAN5546HMoore Thomas P · Basalt, CON5546JRegistration Pending · Danbury, CTRegistration pendingN5546QBrant Ryan L · Meyersdale, PAN5546RGorn Joel · Lawrence, MAN5546SChoice Vc LLC · Oakland, MIN5547QMooney N5547q LLC · Sacramento, CAN55482Crook Mark E · Elberton, GAN5548LUnruly Passengers LLC · Piedmont, SCN5548SGardner Timothy J · Gardnerville, NVN5549AGeoterra Inc · Eugene, ORN5549NRfd Aero LLC · Wilsonville, ORN5549SArdizzone Mark Robert · Mckinney, TXN554DKRvest Management LLC · Boulder City, NVN5550JOptima Aviation LLC DBA · Lewisville, TXN5550QReal Jonathan Dan · La Jolla, CAN5550YSteiner Paul R · Boerne, TXN55515Fly Cessna LLC · Peoria, AZN5551KSchlamer Robert B · Hernando, FLN5551LPea-Wayman Flight LLC · Daytona Beach, FL
Back to AD 80-25-07 R1