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.

N195PKKourtis Vintage Aviation LLC · Owasso, OKBuilt 1951 · S/N 7712 N195PLPerkins Terence R · Ormond Beach, FLBuilt 1948 · S/N 7262 N195PRRg Aviation Inc · Wilmington, DEBuilt 1952 · S/N 7871 N195PWRieke Rhett · Bigfork, MTBuilt 1949 · S/N 7647 N195QPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N 7743 N195RAJaeb Gerald E · Yankeetown, FLS/N 16099 N195RCDuke Kay L · Darrouzett, TXBuilt 1953 · S/N 16102 N195RERamey Robert L · Rose Hill, KSBuilt 1952 · S/N 7934 N195RJJeffries Ronald G · Manson, WAS/N 7899 N195RKLinnane Cory E · Schaumburg, ILS/N 7393 N195RSInternational Air Services Inc Trustee · Carson City, NVBuilt 1950 · S/N 7594 N195RWWhite Michael D Trustee · Willow Springs, MOFirst renewal noticeBuilt 1948 · S/N 7088 N195SFreedom Leasing Ent Inc · Wilmington, DEBuilt 1952 · S/N 7924 N195SBJones Caleb A · Sanger, TXBuilt 1952 · S/N 7911 N195SCSmith William E · Highland, CABuilt 1949 · S/N 7402 N195SELewis Leigh Wade · Rockledge, FLS/N 7857 N195SMBarron Aviation LLC · Perry, MOBuilt 1949 · S/N 7806 N195STFly4sport LLC · Kasilof, AKBuilt 1950 · S/N 7527 N195TGGoodwin Pilar Z · Lancaster, CABuilt 1949 · S/N 7341 N195TWHenkemeyer Joseph · Cave Creek, AZBuilt 1952 · S/N 7981 N195UDowd Darin R · Frisco, TXBuilt 1951 · S/N 7705 N195VOdom John C · Fredericksburg, TXBuilt 1950 · S/N 7471 N195VFMcfarlane Claude L III · Fitchburg, WIBuilt 1948 · S/N 7268 N195VHKoehn Shane · Scooba, MSBuilt 1949 · S/N 7549 N195WGFisher Group LLC · Ashland City, TNBuilt 1952 · S/N 7926 N195WHCarolina Aero Tech LLC · Hilton Head Island, SCS/N 7324 N195WLRegistration Pending · Coldwater, MIRegistration pendingS/N 7620 N195WSSaloga William A Trustee · Batavia, ILBuilt 1952 · S/N 7908 N195WTRowe James D · Nome, AKBuilt 1954 · S/N 16128 N195XBusinessliner 190 Express LLC · Rogers, MNFirst renewal noticeBuilt 1949 · S/N 7464 N195YYoung Kenneth D · La Verne, CABuilt 1951 · S/N 7629 N19600Corona Police Aero Squadron Inc · Calimesa, CABuilt 1972 · S/N 17260600 N19601Pnl Aviation LLC · Brunswick, MEBuilt 1972 · S/N 17260601 N19602Lucas Mitchell H · Jackson, GABuilt 1972 · S/N 17260602 N19603Stanly Business Consultants LLC · Albemarle, NCBuilt 1972 · S/N 17260603 N19606Stettner George J · Spring Hill, FLBuilt 1972 · S/N 17260605 N19609Johnson Erik S · Navarre, FLBuilt 1972 · S/N 17260607 N1960CSenger Bruce D · Mount Solon, VABuilt 1952 · S/N 7919 N1960FCornerstone Financial Enterprises LLC · Mesquite, NVBuilt 1979 · S/N 17273050 N1960MJereb Robert M · Rohnert Park, CABuilt 1976 · S/N 18264505 N1960XPena Fermina · Brentwood, NYBuilt 1964 · S/N 18256060 N19610Berg John R · San Pedro, CABuilt 1972 · S/N 17260608 N19614Clark David R · Terrebonne, ORBuilt 1972 · S/N 17260611 N19618Seymour David E · Evergreen, COBuilt 1972 · S/N 17260614 N1961BGoose Aviation LLC · Cumberland, WIBuilt 1960 · S/N 17247934 N1961CAeroslat4 LLC · Lewes, DEBuilt 1953 · S/N 26106 N1961DMulligan Kevin S · Port Alexander, AKBuilt 1961 · S/N 1850286 N1961FRemove B4 Flight LLC · Joplin, MOBuilt 1979 · S/N 17273051 N1961MSwindle Malorie J · Birmingham, ALBuilt 1976 · S/N 18264506 N1961UMccarthy Trevor William · Addison, TXBuilt 1974 · S/N U20602312

Back to AD 87-20-03 R2