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.
N5789SSierra Aero Corp · Totowa, NJN5790QSurman Stephen · Draper, UTN5792QScott David L · Nampa, IDN5795DQualitair LLC Trustee · MichelstadtN5795QStandard Charter LLC · Centennial Park, AZN5796QFortier Jeremy · Alma, ARN57986Registered aircraftN5798QBradley Brian · Las Vegas, NVN5799QHanson Bryan R · Shawnee, KSN579JKKopacz Thomas H · Glen Flora, WIN57AMclallen Holdings LLC · Saint Charles, ILN57BMHuerta Holdings Inc · Santa Ana, CAN57CPBryant Stephen · Norwalk, OHN57CVMarsico Gary W · Poland, OHN57EAEwing Andrew M · Santa Rosa Beach, FLN57VBKlingebiel Kurt · Leonardtown, MDN57WHMoon Richard B · Arizona City, AZN580Aeroblayze Aviation LLC · Norman, OKN58016Budley Ltd · Muskegon, MIN5801CFly-A-Way Leasing Corp · Farmington Hills, MIN5801NN5801n LLC · Lewes, DEN5803EIrwin Donald L · Emporia, KSN5804QMoffet Jeffrey C · Lawrence, KSN5805QLam Michael · Bellaire, TXN58060Pacer Flying Club Inc · Millbrae, CAN58062Des Moines Flying Club LLC · Indianola, IAN58065Smith Richard Trustee · Dublin, CAN58079Byrne David P · Ojai, CAN5807QDavis Kevin B · Bellmawr, NJN5807SFisher Gary C · Louisburg, KSN5807TRoyal Treatment Carriers Inc · San Antonio, TXN58086Omg Aviation LLC · Benton, KSN5808APas Services LLC · Townsend, DEN5808PWatson James Christopher · Boerne, TXN5808QSaathoff Michael A · Stockton, MON58097Avinash M Mondkar Md Mc · Payson, AZN5809HN5809h Aviation LLC · Kalispell, MTN5809QSpicer Larry E · Milwaukee, WIN580JZumbrun Dennis L · Montz, LAN580KG Force Air LLC · Columbus, OHN580SUMetro Aviation Inc · Shreveport, LAN58102Laperle George M · Santa Barbara, CAN58103Registered aircraftN58105Mooney Skies Unlimited LLC · Merritt Island, FLN58107Perez Jeremiah · Fort Worth, TXN5811CSon Of A Gun Aviation LLC · Cherry Hill, NJN5811EMoss Jessee C · Ardmore, OKN5811QElliott Areospace LLC · Kalispell, MTN58120Air Giblinski LLC · Sedgwick, KSN5812TRegistered aircraft
Back to AD 80-25-07 R1