OpenAirDocs.org
AD 54-19-01

Registered aircraft · 152

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

N1023NSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 18-1889N1127ASerie Dennis P · Chugiak, AKBuilt 1950 · S/N 18-720N11284Horton Rick S · Plains, MTBuilt 1956 · S/N 18-4737N1144AKramer John Edward · Conroe, TXBuilt 1951 · S/N 18-737N1148ATyrrell Luke L · Fairbanks, AKBuilt 1951 · S/N 18-742N1189CHorton Harold E · Jber, AKS/N 18-2470N118EMSharp Robert M Trustee · Jenks, OKS/N 18-1853N1252CDavis Doyle M · Clancy, MTBuilt 1953 · S/N 18-2491N1291CVand Flyve Klub · Newfolden, MNS/N 18-2502N1347AKalba Shaun B · Pleasant Valley, NYBuilt 1951 · S/N 18-1165N1350CBryant Stephen C · Anchorage, AKS/N 18-2513N13FFVeal Tim S · Kenai, AKBuilt 1954 · S/N 18-3415N14319Erickson Mark D · Valley Springs, SDS/N 18-6359N1456CBrewer Alfred D · Hillsboro, ORBuilt 1953 · S/N 18-2654N1471CNorris Cathy J · Statesville, NCS/N 18-2673N1474CSweeney Brett D · Anchorage, AKBuilt 1953 · S/N 18-2678N150CWCleveland William L · Lander, WYS/N 18-4329N1551PPhillips Kris D · Cordova, AKBuilt 1954 · S/N 18-3704N1611CNorthern Flyway LLC · Anchorage, AKBuilt 1954 · S/N 18-3393N1653PAirmotive Service LLC · Brigham City, UTBuilt 1954 · S/N 18-3768N1754ASchrock Jaden D · Sterling, AKS/N 18-1319N1754PLorring Eric H · Kodiak, AKS/N 18-4074N1759AHargus Betty R · Fort Stockton, TXS/N 18-1325N1788ADavis Nigel L · Helena, MTBuilt 1952 · S/N 18-1658N1793AHickle Lucas · Wasilla, AKS/N 18-1664N1795ASvendsen Gregory Roy · Anchorage, AKBuilt 1952 · S/N 18-1665N181AWKustatan Leasing LLC · Nikiski, AKS/N 18-1743N1820ACaley Robert M · Green, KSBuilt 1952 · S/N 18-1671N1829AMcelligott Joseph P · Ione, ORBuilt 1952 · S/N 18-1679N1852PBennack George H · Lyford, TXBuilt 1955 · S/N 18-4101N1858ALow And Slow LLC · Bozeman, MTBuilt 1953 · S/N 18-1686N1871ASkywagon Aero LLC · Wilmington, DES/N 18-1703N1876AKalarney Kerry T · Olathe, COBuilt 1952 · S/N 18-1712N1886AGriffith Richard B · Sycamore, ILBuilt 1952 · S/N 18-1719N1927AHigh Wind Aviation Services LLC · Ludlow, VTBuilt 1952 · S/N 18-1762N1950PJefferies R Wayne · Durango, COBuilt 1955 · S/N 18-4176N1952PWinterton Gary S · Lindon, UTBuilt 1955 · S/N 18-4178N1959AWhite B Scott · Castlewood, VABuilt 1952 · S/N 18-1801N1968PWygant Michelle R · Copper Center, AKBuilt 1957 · S/N 18-4200N1984ASuper D Group LLC · Hanoverton, OHBuilt 1952 · S/N 18-1808N1988ABroussard Lewis A Jr · Morse, LABuilt 1952 · S/N 18-1813N2154ANoska Frank S IV · Wasilla, AKBuilt 1952 · S/N 18-1864N2261AFlying Start LLC · Wilmington, DEBuilt 1952 · S/N 18-1887N2353XB R Trucking LLC · Cut Bank, MTBuilt 1956 · S/N 18-4239N2359PRyan Good Aviation LLC · Sioux Falls, SDBuilt 1955 · S/N 18-4245N245KWCarson Cubs LLC · Yelm, WAS/N 18-2495N2496PTri M LLC · Nikiski, AKS/N 18-4305N2576PWiltz Brothers Inc · Krotz Springs, LABuilt 1955 · S/N 18-4316N2660AN62689 Inc · Texarkana, TXBuilt 1952 · S/N 18-2184N2666PBerentson Bradley J · Westhope, NDBuilt 1955 · S/N 18-4390
Back to AD 54-19-01