Skip to content

Registered aircraft · 17,027

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

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') ORDER BY n_number

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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N2102FOlson Tim O · Saint Onge, SDBuilt 1964 · S/N U206-0302 N2104FBrown Steven R · Soldotna, AKBuilt 1964 · S/N U206-0304 N2104RRegistration Pending · Palm Beach Gardens, FLRegistration pendingS/N 18255304 N2105FClik Services LLC · Forestdale, MABuilt 1964 · S/N U206-0305 N2105QBarreto Daniel · Enterprise, ALBuilt 1974 · S/N 177RG0505 N2107FRymski Daniel L · Colorado Springs, COBuilt 1965 · S/N U206-0307 N2107RDickman Steve · Anchorage, AKBuilt 1964 · S/N 18255307 N2108RWard Neal Cpas Pc · Scottsdale, AZBuilt 1964 · S/N 18255308 N2109RVilt Jared J · Phelan, CABuilt 1964 · S/N 18255309 N210ADUniplane Inc Trustee · Wilmington, DEBuilt 1967 · S/N 210-58835 N210APRegistration Pending · Wilmington, DERegistration pendingBuilt 1965 · S/N 21058713 N210ATTeeters David A · Salinas, CABuilt 1969 · S/N 21059186 N210AWJohnson Matt R · Fox Island, WABuilt 1964 · S/N 21058492 N210DFHampton Harvey E · Simms, MTBuilt 1968 · S/N T210-0397 N210DWBlomberg Nicholas R · Macon, MOBuilt 1967 · S/N 21058876 N210EBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058365 N210EGCenturion Aviation LLC · Nokesville, VAS/N 21059133 N210ETVroom Consulting Inc · Ithaca, NYFirst renewal noticeBuilt 1968 · S/N 21059079 N210FCatron Stephen R · Kansas City, MOS/N T210-0244 N210GGWiegler Michael · Austin, TXBuilt 1966 · S/N 21058790 N210JRowdy Mcbride Hunting Services LLC · Alpine, TXBuilt 1968 · S/N 21059076 N210KHitchcock Mark James · Scottsdale, AZBuilt 1970 · S/N 21059401 N210KEKampel Thomas E · Wellsville, PAS/N 21058505 N210LDPurcell Darrell Ray · Yuma, AZBuilt 1968 · S/N 21059094 N210MMMarble Aviation LLC · Ball Ground, GABuilt 1971 · S/N 21059491 N210NBurton Stone LLC · Durango, COBuilt 1969 · S/N 21059102 N210NMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N 21059255 N210PEVan Dyke Gary D · Pleasant Grove, CABuilt 1969 · S/N 21059180 N210SCSpence C Jason · New Braunfels, TXBuilt 1967 · S/N 21058888 N210WMBryan-Kennedy LLC · Tulsa, OKBuilt 1963 · S/N 21058287 N210WSOlin David G · Jupiter, FLFirst renewal noticeBuilt 1969 · S/N 21059135 N210XLInternational Air Services Inc Trustee · Carson City, NVBuilt 1963 · S/N 205-0364 N210XXRegistration Pending · Porter, TXRegistration pendingBuilt 1964 · S/N 21058402 N210YPartners Aviation LLC · Wilmington, DEBuilt 1970 · S/N 210-59260 N2112QSoloman Michael Glenn · Dallas, GABuilt 1974 · S/N 177RG0512 N2112RKuspuk School District · Aniak, AKBuilt 1964 · S/N 18255312 N2113FBunde Kermit A · Pocatello, IDBuilt 1964 · S/N U206-0313 N2113RStrong Tower Aviation LLC · Trenton, FLS/N 18255313 N2114XGsi Corp · Eastham, MABuilt 1970 · S/N 17259495 N2115MRedman Company LLC · Troy, MIBuilt 1972 · S/N 177-01703 N2116RS&H Aviation LLC · Myrtle, MSBuilt 1964 · S/N 18255316 N21177Valiair Lc Trustee · Casper, WYBuilt 1970 · S/N 177-01578 N2117FHelms Stephen · Anchorage, AKBuilt 1964 · S/N U206-0317 N2117QGately Brian · Brooklyn, NYBuilt 1974 · S/N 177RG0517 N2117RAlt Oliver B · Newberry, FLBuilt 1964 · S/N 18255317 N2118RKopecki Carin E · Hobson, TXFirst renewal noticeBuilt 1964 · S/N 18255318 N2119RAviation Boosters Inc · Sparta, NJBuilt 1964 · S/N 18255319 N211ASBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 20700259 N211SQRare Air Inc · Waterford, MEBuilt 1971 · S/N 18260755 N211TKJaye Jeffrey S · Vacaville, CABuilt 1966 · S/N 18257295

Back to AD 72-03-03 R3