Registered aircraft · 54,015

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.

N724TJPellow James A · Dixie, WAS/N 17254147 N724TMMorcom Aviation Services Inc DBA · Everett, WABuilt 1974 · S/N 17262971 N724TXStratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263381 N725Butler Harris K III · Towanda, KSBuilt 1964 · S/N 185-0737 N7250NSimon Jevon · Buckley, WABuilt 1979 · S/N 21063213 N7250QSale Reported · Crystal, MNSale reported, pending cancellationBuilt 1972 · S/N 17260550 N7251AHoward F Bret · Albany, OHBuilt 1956 · S/N 29351 N7251EFord Michael G · Doerun, GABuilt 1959 · S/N 52251 N7251MSkoglun Jon E · Cashmere, WABuilt 1958 · S/N 55551 N7251NThornton Chad · Seattle, WABuilt 1974 · S/N 18263042 N7251QGarcia Crystal M · Brownsville, ORBuilt 1972 · S/N 17260551 N7251XCampbell Jennings R Jr · Bell, FLBuilt 1961 · S/N 15059351 N7252ABarbaro Aaron J · Marcellus, NYBuilt 1956 · S/N 29352 N7252GLeaders Flying Service LLC · Clear Lake, MNBuilt 1970 · S/N 17258952 N7252MFoxglove Melanie Ann · Captain Cook, HIS/N 55552 N7252QRobbins Aviation LLC · Scottsbluff, NEBuilt 1972 · S/N 17260552 N7253GOne Mile LLC · Canton, GABuilt 1970 · S/N 17258953 N7253QHarry'S Hawks · Wells, MNBuilt 1972 · S/N 17260553 N7254AStiffey Jason J · Port Orchard, WAS/N 29354 N7254MPa Prospect Corp · Columbus, MTBuilt 1958 · S/N 55554 N7254NChoice Aviation LLC · Hamilton, MTBuilt 1974 · S/N 18263044 N7254QRegistration Pending · Phoenix, AZRegistration pendingBuilt 1972 · S/N 17260554 N7254SNickels Robert D · Fayetteville, TNBuilt 1967 · S/N 15067954 N7255ANunziato Anthony J · Tewksbury, MABuilt 1956 · S/N 29355 N7255EValley Pilots Flying Club Inc · Martinez, CABuilt 1959 · S/N 52255 N7255MLdg Aviation LLC · Carefree, AZBuilt 1958 · S/N 55555 N7255QSierra Sky Aviation LLC · Kalispell, MTS/N 17260555 N72579Allee Mark J · Gillette, WYBuilt 1967 · S/N 15067593 N7257AJones William Shane · Griffin, GABuilt 1956 · S/N 29357 N7257MParker Charles B · North Pole, AKBuilt 1958 · S/N 55557 N7257NPeterson Winston Roy II · Arbuckle, CABuilt 1976 · S/N U20603588 N7257QSmith Henry C III · Essexville, MIBuilt 1972 · S/N 17260557 N7257SFidalgo Flyers LLC · Anacortes, WABuilt 1967 · S/N 15067957 N7257XBuckelew James E · Gulf Breeze, FLBuilt 1961 · S/N 15059357 N7258International Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 172RG-0508 N7258ANguyen Anthony V · Keyser, WVBuilt 1956 · S/N 29358 N7258MJj Flyers LLC · Corinth, MSBuilt 1958 · S/N 55558 N7258SBusiness As Usual LLC · Spartanburg, SCBuilt 1967 · S/N 15067958 N7258TAutry Stephen W · Durango, COBuilt 1959 · S/N 46858 N7259AHalladay Roy · Erie, COS/N 29359 N7259EWiley Jerry Lynn · Mission, TXBuilt 1959 · S/N 52259 N7259GLuevano Eric · Huntington Beach, CAS/N 18263318 N7259MRosario Ted · Salome, AZBuilt 1958 · S/N 55559 N7259QForbes Gregory Allan · Lowell, MIBuilt 1972 · S/N 17260559 N7259SSchafer Louis L · Murfreesboro, TNBuilt 1967 · S/N 15067959 N7259THarrington Everett Dean · Council, IDBuilt 1959 · S/N 46859 N7259XRedtail LLC · Lafayette, COBuilt 1961 · S/N 15059359 N725ASGeorgia Co Of Aspiring Flyers LLC · Clarkesville, GABuilt 1978 · S/N 18266640 N725BBScenic Concepts LLC · La Crosse, WIBuilt 1976 · S/N 17267802 N725BKAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259821

Back to AD 87-20-03 R2