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.
N36213N36213 Aircraft Ownership LLC · The Woodlands, TXN3621CAirplane 1 LLC · Warren, NHN36233Meyer Wayne G · Bozeman, MTN36242Landmark Search Group · Spokane, WAN36244Neel Aviation LLC · Lakeland, FLN36245Ridge Logan D · Lake City, ARN36246Sikes Ethan L · Collins, GAN36248Sipes Austin L Jr · North Pole, AKN36249Davis Gary L · Sun City, AZN36250Floura David P · Blackduck, MNN36251Gourley Eric G · Eastsound, WAN3625CBurton Michael A · Chicago, ILN36266Barney Bill L · Fairbanks, AKN36267Ashcraft Keirsten · Longview, TXN3626CCowey Kevin M · Pittsburgh, PAN3627CWebb Brent · Safford, AZN3627EJmch Flight LLC · Henderson, NVN36285Schreiber Ray R · New Palestine, INN36288Monke David W · Fontanelle, NEN3628HCutilo Jonathan C · Pottstown, PAN3629HHolley Victor R · Seneca, SCN362BCWing Nutz LLC · Redondo Beach, CAN362BLLabelle Brendan · Huntington, NYN362CAChoice Aviation LLC · Hamilton, MTN3630NSalvesen William · Clermont, NJN3631EMudcat Construction Inc · Beattyville, KYN3632EHigh Exposure Inc · Wilmington, DEFirst renewal noticeN36335Simmons Darren · Diamondhead, MSN36336Mierzejewski Karl · State College, PAN36337Boling Derek · Paragould, ARN3633NPerotti Camille C · Carolina Beach, NCN36349Richardson Thomas R · Valleyford, WAN36350Hennager Eric D · Langdon, NDN36351Mueller Michael A · Seguin, TXN36352Smith Steven Glen Trustee · Orem, UTN36353Mcbride Mark · Sutton, MAN3637CThree Seven Charlie LLC · Camp Hill, PAN36382Pallaziol Delia N · Vista, CAN3638HQuantie Harold G · Locust Grove, OKN3639HBeatty Earl IV · Gambrills, MDN3640NShaikh Samir K · Schaumburg, ILN36411Runsick Michael C · Wynne, ARN36412Martinsen John James · Aberdeen, WAN36413Steward James D · Monument, CON36414Dewitt Elvin H · Santa Monica, CAN36417Huber Weylin L · Aberdeen, SDN3641CFeldmann D Joshua · Epworth, IAN3641NVilliger Arnold H · Henry, ILN36434Phillips Aaron W · Fort Scott, KSN36438Dorman Richard E · Mesa, WA
Back to AD 80-25-07 R1