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.

N727PBRegistration Pending · Farson, WYRegistration pendingBuilt 1973 · S/N 18262260 N727PCPb&J Holding LLC · Franktown, COBuilt 1979 · S/N 18267396 N727PMMiddlebrook Paul E · Penn Yan, NYBuilt 1981 · S/N 17275485 N727RCKelley Aircraft LLC · Weyers Cave, VABuilt 1974 · S/N 17263887 N727SFRenko Steven E · Elmira, NYBuilt 1968 · S/N 17256791 N727SGCarbaugh Nicholas · Seattle, WAS/N 30405 N727TLLangebrake Lawrence C · Saint Petersburg, FLBuilt 1977 · S/N 17269372 N727TSStreng Terry E · Columbus, OHBuilt 1973 · S/N 17262367 N727WSRobey Sean C · Camden, NCFirst renewal noticeBuilt 1978 · S/N 21063140 N727ZTeam Alaska LLC · Anchorage, AKBuilt 1953 · S/N 25542 N727ZGNelson Poultry Farms Inc · Manhattan, KSBuilt 1961 · S/N 17248125 N728United States Department Of Interior · Boise, IDBuilt 1985 · S/N U20606877 N7280AWarren Holland S · Princeville, ILFirst renewal noticeBuilt 1956 · S/N 29380 N7281AWindsock Capital LLC · Bertram, TXBuilt 1956 · S/N 29381 N7281TBreier Clifford G · Dardanelle, ARBuilt 1959 · S/N 46881 N7281XBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 15059381 N7282GDurley Randal W · Talladega, ALFirst renewal noticeBuilt 1973 · S/N 15074634 N7282MDom Michael R · Kingman, AZRegistration expired, pending cancellationBuilt 1958 · S/N 55582 N7282SDavis Patrick I · Acampo, CABuilt 1967 · S/N 15067982 N7283EKirstein Terence C · Gilbert, AZBuilt 1959 · S/N 52283 N7283GPetersen Conrad H · Kenmare, NDBuilt 1973 · S/N 15074635 N7283SMiller Bambi · Lee, NHS/N 15067983 N7284EFoster Craig M · Chandler, AZBuilt 1959 · S/N 52284 N7284GFisher Global LLC · Faulkner, ARBuilt 1970 · S/N 17258984 N7284MColeman Douglas A · Hubbard, ORBuilt 1958 · S/N 55584 N7284NMcbride Kelly · Show Low, AZBuilt 1974 · S/N 18263071 N7285EAtchley Mark · Anthony, NMBuilt 1959 · S/N 52285 N7285MLefritz Richard A · Welches, ORFirst renewal noticeBuilt 1958 · S/N 55585 N7285NSale Reported · Fish Haven, IDSale reported, canceledBuilt 1974 · S/N 18263072 N7285QEight Five Quebec Assoc LLC · Tucson, AZBuilt 1973 · S/N 18262056 N7285SHenry Mark A · Dickinson, TXBuilt 1967 · S/N 15067985 N7285XDover Rod S · Goldendale, WABuilt 1961 · S/N 15059385 N7286ALipp James Oliver · Nesconset, NYBuilt 1956 · S/N 29386 N7286EThiede Robert E · Palmer, AKS/N 52286 N7286GRegistered aircraftBuilt 1973 · S/N 15074636 N7286QLacombe Bryan K · Rockwall, TXBuilt 1972 · S/N 17260586 N7286SMaychezak Lana R · Sentinel Butte, NDBuilt 1967 · S/N 15067986 N7286XKillian James D · Oakwood, GABuilt 1961 · S/N 15059386 N7287ADean William D · Jasper, GABuilt 1956 · S/N 29387 N7287GTen Mile Ranch Inc · Vale, ORBuilt 1970 · S/N 17258987 N7287MFrenzel Carl O · Midlothian, TXBuilt 1958 · S/N 55587 N7287TRfk Aerospace LLC · Clayton, NCBuilt 1959 · S/N 46887 N72884Hawkeye Aviation LLC · Miami, FLBuilt 1974 · S/N 17264315 N7288AHeard Benjamin A · Ellensburg, WABuilt 1956 · S/N 29388 N7288EGay C R · Eagle Creek, ORBuilt 1959 · S/N 52288 N7288MStraight Tail LLC · Boise, IDBuilt 1958 · S/N 55588 N7288QAerosmith Aviation LLC · Marietta, GAFirst renewal noticeS/N 17260588 N7288TSandusky Flight Academy LLC · Sandusky, MIBuilt 1959 · S/N 46888 N7289EMidfield Aviation LLC · Caldwell, IDS/N 52289 N7289NCandle Lane LLC · Sherman, CTBuilt 1974 · S/N 18263076

Back to AD 87-20-03 R2