AD 2016-01-01
Registered aircraft · 412
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:2016-01-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:2016-01-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:2016-01-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:2016-01-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.
N46PLAvcorp Leasing Inc Trustee · Wilmington, DEN4757SBombay Glass Corp · Depoe Bay, ORN477HCParish Air Inc · San Diego, CAN47HPBuddy Air LLC · West Bend, WIN481CBTern Royal LLC · Camp Hill, PAN4839RGnome Holding Company LLC · Columbus, GAN487LBarkair LLC · Alpine, WYN488WAEcc Corp · Cumberland, RIN492FZFishkind Aircraft Holding LLC · Orlando, FLN49BTFlight Levels LLC · Ridgeland, MSN4NYLesair LLC · Framingham, MAN500BRSevenlimamike LLC · Cleveland, TNN500HAWandering Quarks LLC · Lincolnville, MEN500JM500jm Aviation LLC · Westfield, INN500JRReel Aviators LLC · Scottsdale, AZN500PEO2flyhi LLC · Brooksville, FLN500XRRjt Equipment LLC · Lubbock, TXN509PM777tz LLC · Lubbock, TXN50GKRedwood Air LLC · Roanoke, TXN51019Lohmann Jack R · Frisco, CON512MMBuckeye Creek Ventures LLC · Belle Plaine, IAN515BRDmfs Leasing LLC · Des Moines, IAN515CTMalibu LLC · Portland, ORN520HPHutton Mark · Denison, TXN5215UTwin Peaks Aviation LLC · Missoula, MTN524PMSky Train Air LLC · Templeton, CAN526AGValiair Lc Trustee · Casper, WYN526FGTuggle David Eric · Albuquerque, NMN529PMCarolina Express LLC · Fairmont, MNN530HPCreek Canyon Aviation LLC · Phoenix, AZN5319KEyedollar LLC · Denton, TXN5320NSaunders Aviation LLC · Lewes, DEN5322DBlack Phoenix Photography LLC · Morgan Hill, CAN5322MFlight Club LLC · Erie, PAN53235Aerospace Trust Management LLC Trustee · Wilmington, DEN5325PJpr Investments LLC #51 · Fargo, NDN5329QMitzel Eddy Jacob · Mandan, NDN532STNovaair LLC · Lake Sherwood, CAN53369Poor Boy Aero LLC · Seminole, TXN5337NInternational Air Services Inc Trustee · Carson City, NVN5338MAircraft Guaranty Corp Trustee · Oklahoma City, OKN5339G5339g LLC · Vero Beach, FLFirst renewal noticeN5341CMobilesphere LLC · Cambridge, MAN5347VDe Boissard Karen · New York, NYN53516Flight Group LLC · Bend, ORN5353VMidwest Ventures LLC · Wichita, KSN5355SJohn Galt Industries LLC · Charlevoix, MIN5358JAdams Aviation Services Inc Trustee · Wilmington, DEN535JRGreenville Pickens Roundtrac LLC · Easley, SCN5361AChavers Construction Inc · Cantonment, FL
Back to AD 2016-01-01