Registered aircraft · 54,017

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.

N568QAWhite Fence Aero LLC · Denver, COBuilt 1971 · S/N 18260932 N568WCormell Eric M · Caldwell, IDBuilt 1979 · S/N 18266813 N5690RMcveigh Ian Thomas · Mansfield, TXBuilt 1965 · S/N 17253334 N5690TJohnson Clinton A · Haughton, LABuilt 1964 · S/N 17251590 N5691RBase 2 Final Fleet LLC · Mckinney, TXBuilt 1965 · S/N 17253336 N5691TEsterly Bryan L · Hope Mills, NCBuilt 1964 · S/N 17251591 N5692AKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1956 · S/N 28292 N5692JSeawings LLC · Holualoa, HIBuilt 1974 · S/N 18263494 N5693GScott Jerry · Wingate, TXBuilt 1969 · S/N 15071193 N5694BKrukow Jonathan L · Hampton, IABuilt 1956 · S/N 33694 N5694GN528r LLC · Auburn, ALBuilt 1969 · S/N 15071194 N5695TJohnston David L · Williamsville, MOBuilt 1964 · S/N 17251595 N5696ACardinal Wings Inc · Faribault, MNBuilt 1956 · S/N 28296 N5696BSkyways Group · Albuquerque, NMBuilt 1956 · S/N 33696 N5696GLowry David N · Fairport, NYBuilt 1969 · S/N 15071196 N5696RMagnolia Flight Aviation LLC · Pontotoc, MSBuilt 1965 · S/N 17253343 N5697AHam Dana L · Claremore, OKBuilt 1956 · S/N 28297 N5697ERedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 17271922 N5697JRidgway Rick J · Carlisle, INBuilt 1970 · S/N 18800647 N5698AGreer David S · Lubbock, TXBuilt 1956 · S/N 28298 N5698BTilley Melvin D · Sperry, OKBuilt 1956 · S/N 33698 N5698GKessler Frank J Jr · Gallatin, TNS/N 15071198 N5699AOhlinger Judith A · Copley, OHBuilt 1956 · S/N 28299 N5699RNoriega Vanessa · Miami, FLS/N 17253349 N569APotopowitz William III · Niantic, CTS/N 15070351 N569ARN717dz LLC · Lovell, WYS/N 18267746 N569GSTwin Cities Flight Training Inc · Blaine, MNBuilt 1971 · S/N 15072763 N569NEMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1978 · S/N 15282580 N56ACLatham Randall W · Georgetown, OHBuilt 1964 · S/N 17252416 N56AKLonghorn Leasing LLC · Anchorage, AKS/N U20605353 N56BPCeballos Oscar Felipe · San Ysidro, CABuilt 1978 · S/N P21000064 N56CKThurber Mark C · Manchester, MDBuilt 1962 · S/N 21058112 N56DCAero Services Lc · Woods Cross, UTBuilt 1967 · S/N T210-0280 N56DGEagle East Aviation Inc · North Andover, MABuilt 1976 · S/N 17266239 N56DSM E L LLC · Wilmington, DEBuilt 1973 · S/N P3370048 N56ECBpc Aviation LLC · Rosamond, CABuilt 1962 · S/N 17249661 N56EPSanders Flight Training Center Inc · Jasper, ALBuilt 1978 · S/N 17270728 N56FAir Kings LLC · West Chester, PABuilt 1975 · S/N 17265348 N56FASilver Express Co DBA · Miami, FLBuilt 1978 · S/N 172-69682 N56GCziraky Michael T · Brookhaven, PABuilt 1949 · S/N 19099 N56JRMccollum Eric B · Fair Oaks, CAS/N 17248012 N56LJL & J Aviation Inc · Atwater, CABuilt 1979 · S/N 17272751 N56MNugent David R · Jensen Beach, FLBuilt 1960 · S/N 52761 N56MTAvex Holdings Heli Inc · Lewes, DES/N 32562 N56MWHeartland Ag Aviation LLC · Lancaster, KSBuilt 1975 · S/N 17265314 N56NLExtra Air LLC · Port Orange, FLBuilt 1977 · S/N R18200084 N56QWJefferson City Aviation Inc · Jefferson City, MOBuilt 1976 · S/N 150-78863 N56SLemberger John R · West Lake Hills, TXBuilt 1974 · S/N P3370173 N56TVKoerper Md LLC · Las Cruces, NMBuilt 1984 · S/N 18268399 N56WKarpik Joseph P · Floodwood, MNFirst renewal noticeBuilt 1952 · S/N 7952

Back to AD 87-20-03 R2