Registered aircraft · 54,019

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

N2108ERedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 17271159 N2108RWard Neal Cpas Pc · Scottsdale, AZBuilt 1964 · S/N 18255308 N2108URoy Roland P · Lewiston, MEBuilt 1956 · S/N 29480 N2108YNorthwest Wings LLC · Hillsboro, ORBuilt 1962 · S/N 17249608 N21093Matson John R · Stoughton, WIBuilt 1972 · S/N 18261408 N21096Ballard Gregg A · Cedar City, UTBuilt 1972 · S/N 18261411 N21097Atb Aviation LLC · Wilmington, DEBuilt 1972 · S/N 18261412 N21099Ricke Ryan · Hutchinson, MNBuilt 1972 · S/N 18261413 N2109RVilt Jared J · Phelan, CABuilt 1964 · S/N 18255309 N2109YSnyder Chris · Olean, NYBuilt 1963 · S/N 17249609 N210AAMeckley Sean H · Seattle, WABuilt 1982 · S/N 21064690 N210ABRudy Schmitt · Brookshire, TXS/N 21059209 N210ADUniplane Inc Trustee · Wilmington, DEBuilt 1967 · S/N 210-58835 N210AKMaxinkuckee Aviation LLC · Columbus, INS/N 21061627 N210ANCalifornia In Nice Inc · San Jose, CABuilt 1975 · S/N 17264678 N210APRegistration Pending · Wilmington, DERegistration pendingBuilt 1965 · S/N 21058713 N210ARVjc Air LLC · Katy, TXBuilt 1975 · S/N 21061077 N210ATTeeters David A · Salinas, CABuilt 1969 · S/N 21059186 N210AWJohnson Matt R · Fox Island, WABuilt 1964 · S/N 21058492 N210AXKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1979 · S/N 21063033 N210AZAerialtraders LLC · Estero, FLBuilt 1972 · S/N 21059678 N210BBCherry Hill Aviation C182 LLC · Freetown, INBuilt 1979 · S/N R18201430 N210BESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N P210-00088 N210BGTurner Kenneth W · Arlington, WABuilt 1978 · S/N P21000025 N210BHGlenn Wade Corp · Tucson, AZBuilt 1975 · S/N 21060954 N210BJSummers Equipment Leasing Inc · Wilmington, DEBuilt 1974 · S/N 21060221 N210BNBy Land Air And Sea LLC · Alto, MIBuilt 1974 · S/N 21060526 N210BPBbsc LLC · Wilmington, DEBuilt 1981 · S/N 21064300 N210BTGood Aviation LLC · Oshkosh, WIBuilt 1979 · S/N P21000555 N210BVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 21061114 N210BWSc & Dss LLC · Mckinney, TXBuilt 1976 · S/N 21061483 N210BXNova Aircraft Holdings Inc · San Diego, CABuilt 1972 · S/N 21059583 N210CJettech Holdings LLC · Broomfield, COBuilt 1979 · S/N P21000218 N210CCMuller Rodolfo · Kerrville, TXBuilt 1978 · S/N 21063008 N210CEMaas Aviation LLC · Pewaukee, WIBuilt 1980 · S/N P21000563 N210CFQuest Aviation Inc · Lake City, FLBuilt 1978 · S/N 21063124 N210CHOne Up LLC · Stuttgart, ARBuilt 1974 · S/N 21060142 N210CPToeppen Chris P · Atherton, CABuilt 1979 · S/N P21000230 N210CUTcl Fbo LLC · Tuscaloosa, ALBuilt 1981 · S/N 21064452 N210CWBeach Partnership LLC · Myrtle Beach, SCBuilt 1979 · S/N 21063595 N210CX210 Equipment LLC · Lexington, SCBuilt 1972 · S/N 210-59719 N210DCRrr Land & Cattle Co LLC · Midland, TXBuilt 1973 · S/N 21060159 N210DDDwoskin David F Trustee · San Pedro, CABuilt 1976 · S/N 21061464 N210DFHampton Harvey E · Simms, MTBuilt 1968 · S/N T210-0397 N210DGWashburn Stig K · Westminster, MABuilt 1972 · S/N 21059559 N210DLDaneco LLC · Houma, LABuilt 1978 · S/N P21000114 N210DMHans Nelson And Son Nursery Inc · Boring, ORS/N T210-62902 N210DNMartin John J · Honesdale, PAS/N 21059676 N210DRRaid Air LLC · Grand Rapids, MNBuilt 1978 · S/N 21063011 N210DSSevel Garry S · Fresno, CABuilt 1981 · S/N 21064275

Back to AD 87-20-03 R2