AD 2000-25-02 R1
Registered aircraft · 7,560
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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.
N1705ZJohnston Daryl T · Euless, TXN1706ECrabbe Michael B · Galloway, OHN170MLLacey David G · Locust Grove, GAN1712ECrooks Sean P · Canton, MIN1713EMurray Donald L · Two Harbors, MNN1714ELeonx Aaron R · Cambridge, WIN1715EDelong Erika D · Forest Lake, MNN1719MJohnson David H · Jasper, GAN171CRLaniape LLC · Fort Walton Beach, FLN171HBKrawchuck Paul L · Live Oak, FLN171TGarrett Wayne · Guntersville, ALN1724EMorgan John T · Fort Payne, ALN1726ESale Reported · Overland Park, KSSale reportedN1729EFogg William R · Greensburg, INN1731EWelton Doug L · Fairbanks, AKN1739EWilson Bobby R · Kathleen, GAN173PWSunspot Meadow LLC · Cloudcroft, NMN173SDMountain Aerobatics LLC · Chesterfield, MON1744EDietz Steven C · Poplar Grove, ILN1749EPrice William B · Lamar, SCN174RAWelke Gregory E · Chippewa Falls, WIN174RCCarsey Rick · Fowler, CAN174SGMoore Stan · Amarillo, TXN174TBOwen Harold E Jr · Collierville, TNN1751ELowe Thomas E · Crystal Lake, ILN1752EStoos Robert A · Lakeland, FLN1756ESlg Aviation LLC · Berlin, WIN175RABrabec Frank F · Indio, CAN175RLPerera Nandana L · Logan, OHN1762EKopecky Carle J · Warnerville, NYN1763EKohn Michael E · Endicott, NYN1764EBlackwood Edward W Jr · Mt Holly, NCN1766EKottemann Gregory C · Kentwood, LAN1770ESimmers Jonathan P · Mandan, NDN1771EBerntsen Bradley T Trustee · Apple Valley, MNN1774EKendall Jeffrey A · Vero Beach, FLN177ACIsaac Bron A · Soldotna, AKN1780EKalb Kenneth R · Dubois, INN1785EHamlett Reece W · Anchorage, AKN1787EStevens Jerrold B · Salem, ORN1789EPinkston Billy Walker · Lambert, MSN178BCAllen Lisa M · Melba, IDN178DKSchenck James R Trustee · Mclean, VAN178TTLockwood Kurt G · Fairbanks, AKN1790EMountain Flyers LLC · Milton Freewater, ORN1792EHowe Patrick L · Higgins Lake, MIN1797ESmokovitz Daniel J · Brighton, MIN1798EStewarts Aircraft Service Inc · Waynesville, OHN1799EAndresen Paul S · Chandler, AZN179BCDenmark Ag · Winters, CA
Back to AD 2000-25-02 R1