AD 2000-25-02 R1
Registered aircraft · 7,563
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.
N9635SPake Bradley P · Felton, MNN9636ETaylor Sophia · Urbana, OHN963TTAmerican Capital Aviation LLC · Kalispell, MTN9640SFrancis James E · King City, CAN9641ELoudon Philip G · Fairbanks, AKN9642STaylor Jonathan K II · Granbury, TXN9643STurner Nathan D · Nenana, AKFirst renewal noticeN9644SClausen Robert G · Argyle, MNN9645EWalsemann Brent M · Carthage, NYN9646EEmbree Walter G · Harrisonburg, VAN9647EEvans Mark O · Dover, ARN9647SGarrett Flying Service · Danbury, TXN9649SHowell Alice R · Bainbridge, GAN964SEGray Luke Francis · San Bruno, CAN9650EWalton John F · Hesperia, CAN9651EMacveigh Craig A · New Carlisle, OHN9653SNy Barnstormers LLC · Maine, NYN9654EAlbij3 LLC · Milton, FLN9655HHetz Richard A · Fairview, PAN9657SWhite Wayne A · Scenic, SDN9658EPrivitt Bret J · Fort Worth, TXN9659ERegistered aircraftN-number assigned, not yet registeredN9659SRandall Timothy J · Skidmore, MON965JRichardson Cotton Inc · Wilmington, DEN965MAFirst Aero Group LLC · Wilmington, DEN9660EHoffman Allen D Sr · Cheboygan, MIN9660SHughes Alan J · Edison, OHN9661ECard Donald J · Dallas, TXN9662EEnnenga Robert B · Grand Haven, MIN9665EFurnas Jerry W · San Diego, CAN9665SDendy Dwight E · Caledonia, ILN9667SJones Larry C · Clovis, NMN9668SPalmer Kit A · Redlands, CAN966BCHutchins David E · Squaw Lake, MNN9670SDowns Steve M · Camden, TNN9675EJersey George H · Cold Brook, NYN9677EBoyd Jeff · Justin, TXN9679SBistline John A · Cedar City, UTN967CMDonaldson Charles A · Clay City, KYN9681EDaniel Stephen Clay · Decatur, GAN9682SRoethlisberger John · Beaver Falls, PAN9684EArcher William P · Wapato, WAN9684SGt Aviation LLC · Kalispell, MTN9685SSymond Clarence B · Eastover, NCN9686SAirpro Aviation LLC · Cross Lake Twp, MEN9687SHayes Brian · Vero Beach, FLN9688SFay Daniel J · Houston, TXN968BCAmerican Champion Aircraft Corp · Rochester, WIN9690SAck & Co LLC · East Helena, MTN9692ESeever James J · Holmen, WI
Back to AD 2000-25-02 R1