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.
N1844EOxygen Aviation Inc · Townsend, DEN1844GTwenty One Miles LLC · Woodland Hills, CAN1845MRaapana Patrick M · Fairbanks, AKN1846EBlue Northern Sky Flute LLC · Hinckley, ILN1847EGuillen William · Saint Cloud, FLN1847GRogers Joe E · Manvel, TXN1848EWillis James R · Belleview, FLN1850GMadison Nicholas R · Fayette, ALN1851EWoody James C Jr · Greenville, NCN1856GGray Timothy V · Clearbrook, MNN185ACFulton Lanny G · Spartanburg, SCN1862EWalker James P · Tifton, GAN1862GEdwards Keith C · Gloversville, NYN1863EHager Spraying Service Inc · Barney, NDN1863GGriffin Robert G · Anchorage, AKN1864EMcalister Bryan · Lindsay, TXN1864M172 Fayette Inc · La Grange, TXN1865EWhite Duane A · Wappingers Falls, NYN1865GCallie Capital LLC · Prairie Village, KSN1866GNicollet Flying Club Inc · Nicollet, MNN1868ETranby James O · Minot, NDN1868GBrown Kirk W · Spring Branch, TXN1869EMiller Randall D · Grand Junction, CON1869GMcdaniel Ronnie · Starkville, MSN186ACHartman James R Trustee · Everett, WAN186RABig T Aviation LLC · Wilmington, DEN1871GGrizzle Jason · Roscoe, TXN1872GMcninch Floyd S · Greenville, MEN187LCArd Sammy · Pamplico, SCN187RAWarden Stephen M · Sugar Land, TXN1880GSchool Of Missionary Aviation Technology · Ionia, MIN1882EFreeport Champ Club · Scioto Mills, ILN1884ESnyder Jason D DBA · Oakland, MDN1885EGolden Age Air Museum Inc · Bethel, PAN1885GGoodfriend Neal · Sanger, TXN1887ECobb Ralph B · Nicholasville, KYN1887GJewett Cody C · Isabel, SDN1889GRainbow Flying Service LLC · Moses Lake, WAN188BCWaldron Elijah L · Murfreesboro, TNN188RACook Gary Lee · Ontario, CAN188RSVardaman Charles · Little Rock, ARN1890EPancake C William Jr · Keyser, WVN1892EWimberly Gary E · Weirsdale, FLN1892GSveen Jeffrey S · Edinburg, NDN1893EMclean Diane A · Weirsdale, FLN1893GDuston James D · Columbus, MSN1894GWeyhe Joel J · Medford, ORN1895EIrvine Brian K · Amboy, MNN1895GPost Morgan C · Council Bluffs, IAN1898ETanner Ronald J · Okeechobee, FL
Back to AD 2000-25-02 R1