Registered aircraft · 85,620

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

N199AVEcho Mike LLC · Baldwin, NYBuilt 1981 · S/N 28-8116283 N199BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881956 N199GFogelson Robert A · Benton City, WABuilt 1959 · S/N 52233 N199GWRaleigh Flying Club LLC · Chapel Hill, NCS/N 28-7990268 N199HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 3246126 N199JBOew Aviation LLC · Sumter, SCBuilt 1971 · S/N 28R-7135100 N199JTPena Rivera Luis A · Zephyrhills, FLBuilt 1960 · S/N 24-2323 N199KMOrloff Kenneth Lee Trustee · Groveland, CABuilt 1979 · S/N D-10243 N199LPAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 17264143 N199MCFly N199mc LLC · Nevada City, CABuilt 1977 · S/N 17268570 N199MWWoftam Inc Trustee · Wilmington, DEBuilt 1979 · S/N 327940219 N199PBSkyflite LLC · Hillsboro, ORS/N TJ-137 N199PGArnett Joshua · Lucas, TXBuilt 1982 · S/N 28R-8218020 N199PKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-35694 N199RBArnold Aviation LLC · Huntsville, ALBuilt 1991 · S/N 24-3244 N199RFBravo Charlie Global LLC · Kalispell, MTBuilt 1979 · S/N 18266816 N199RNWestern Flying Club Inc · Burlington, NCBuilt 1977 · S/N 18266079 N199RPId Corporation · Shepherd, MTS/N EA-344 N199TCStearns Nathaniel · Rochester, NYBuilt 1999 · S/N 3257088 N199TKDangel LLC · Hailey, IDBuilt 1979 · S/N P21000313 N199TPBlue Line Aviation LLC · Dunbar, NEBuilt 1972 · S/N 28-7325193 N199WBReinert Joseph Mason DBA · Chattanooga, TNBuilt 1963 · S/N 28-1040 N199YCKruse Adam L · Weiser, IDBuilt 1976 · S/N 18258424 N19ABYong Andrew · Newnan, GABuilt 1964 · S/N D-7701 N19AFBegley Edward R · Glasgow, KYBuilt 1966 · S/N 310K0100 N19AJBayshore Aircraft LLC · Miami, FLBuilt 1979 · S/N 18267286 N19AVGhafouri Mohsen · Murrieta, CABuilt 1981 · S/N 28-8216106 N19AXAircraft Ownership Solutions LLC · Kokomo, INBuilt 1981 · S/N 25-0504 N19BAgricultural Investors LLC · Jacksonville, FLBuilt 1977 · S/N 34-7770293 N19BMRicks Aviation Inc · Wilmington, DEBuilt 1957 · S/N D-5259 N19CAPoulton Bruce A · Fremont, CABuilt 1994 · S/N E-2877 N19CBCirrus Flying Professionals LLC · Hollywood, FLS/N 31-7752012 N19DEchelon Right LLC · Nicholasville, KYBuilt 1980 · S/N 18504097 N19DBDcs Air LLC · Pulaski, WIBuilt 1972 · S/N 310Q0668 N19DJLewis Landon Jon · Hope, NDBuilt 1977 · S/N 310R0868 N19ECSerra Decca Company LLC · Seattle, WABuilt 1967 · S/N 185-1306 N19ESRegistered aircraftBuilt 1980 · S/N TJ-296 N19FABrown Brian T · Wilton, CABuilt 1961 · S/N 18253809 N19FBWojnicki Chester · Mt Prospect, ILBuilt 1976 · S/N 21061668 N19FSCole Properties LLC · Foley, ALBuilt 1983 · S/N TJ-441 N19GCarlton Steve W · Lewiston, IDBuilt 1963 · S/N 18254596 N19GCKobaly Jason D · Yucca Valley, CABuilt 1972 · S/N 18261280 N19GJJmd Aviation LLC · Guilford, CTBuilt 1973 · S/N 28-7405020 N19HJLogan Lonnie L · Grand Island, NEBuilt 1973 · S/N 32-7300020 N19HRJernigan Michael G · Toledo, ORBuilt 1966 · S/N 17255607 N19JGImmeyer Daniel O · Redmond, WABuilt 1958 · S/N 55131 N19KCGrays Bay LLC · Warrenton, ORBuilt 1970 · S/N 274516 N19KYChi Yang · Lafayette, COS/N TE-1073 N19LBSanders Brian L · Tehachapi, CABuilt 1982 · S/N 21064705 N19LFN19lf Corp · Oak Lawn, ILBuilt 1972 · S/N 310Q0622

Back to AD 98-21-21 R1