AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N4443PRealtime Consulting LLC · Winter Park, FLBuilt 1951 · S/N 23079N4443QSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842397N4443RCold Region Air LLC · Fairbanks, AKBuilt 1976 · S/N 18502957N4443TKristofzski John · West Richland, WABuilt 1971 · S/N 28-7105228N4443XFox Two LLC · Camino, CABuilt 1975 · S/N 28R-7635044N4443ZMeekin Michael J · Palmer, AKBuilt 1969 · S/N 18-8788N44441Breeden William N · Gaithersburg, MDBuilt 1966 · S/N 18258015N44442Cummins Stephen Michael · Fenton, MOBuilt 1974 · S/N 28-7405244N44443Jax Navy Flying Club · Jacksonville, FLBuilt 1974 · S/N 28R-7535001N4444AWesolowski Chris E · Anchorage, AKBuilt 1956 · S/N 22-3774N4444EIllsley Roger J · Santa Rosa, CABuilt 1976 · S/N 28-7690250N4444JMoore James Jeffrey · Midlothian, TXBuilt 2004 · S/N 3788N4444KSivyllis Costas · Port Orange, FLFirst renewal noticeBuilt 1964 · S/N D-7422N4444MTurbine Conversions Ltd · Nunica, MIBuilt 1997 · S/N 1APP01-01N4444TKinzie Industries LLC · Alva, OKBuilt 1966 · S/N P206-0290N4444WKoehler Robert E · West Lafayette, INBuilt 1961 · S/N 18253371N44450Brown Roy A · Morongo Valley, CABuilt 1974 · S/N 28-7425412N44452Cdr Aviation LLC · Kalispell, MTS/N 28-7425413N44458Forsman Airways LLC · Glenwood, MNBuilt 1974 · S/N 28R-7435309N4445JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842398N4445KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842399N4445PSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842400N4445SSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842401N4445VSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842402N4445YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842403N44463Sabine Financial Services Inc · Wilmington, DEBuilt 1988 · S/N 4608113N4446JScherr Steven · Mandan, NDBuilt 1967 · S/N 28-22850N4446RSiler Jerry L · Eau Claire, WIBuilt 1974 · S/N 17263188N4446ZGrant Kimberly A · Priest River, IDBuilt 1969 · S/N 18-8792N44478Richard J Farmer II · Fremont, OHBuilt 1974 · S/N 28-7405247N4447ASouth Texas Helicopter Services LLC · Mcallen, TXBuilt 2009 · S/N 12906N4447QWolter Dennis R · Cincinnati, OHBuilt 1973 · S/N 17261719N4447RManos Con Alas Ministries · Sierra Madre, CABuilt 1978 · S/N R18200601N4447VTurkey Holler LLC · Shamrock, TXS/N 12910N44485Registration Pending · Middletown, OHRegistration pendingS/N 28-7415646N44488Daris James · Fitzwilliam, NHBuilt 1974 · S/N 28-7415647N4448HNorthwest Iowa Flyers LLC · Everly, IABuilt 1978 · S/N 24-0736N4448RBell F Robert · Anchorage, AKBuilt 1976 · S/N 18502960N4448THoughton John L · Lamar, MOBuilt 1971 · S/N 28-7105227N4448ZGrow Michael J · Palmer, AKBuilt 1969 · S/N 18-8795N44497English William E · Mason City, IABuilt 1974 · S/N 28-7425417N4449GHuntley John · Bellingham, WABuilt 1962 · S/N 21058087N4449JSinatra Anthony J · Glendale, AZBuilt 1967 · S/N 28-22854N4449RMorrow David · Maynardville, TNBuilt 1978 · S/N R18200602N4449SMccutchen John J II · Houston, TXBuilt 1975 · S/N TC-1873N4449WJameson Clarke Enterprises LLC · Houston, TXBuilt 1974 · S/N TH-451N4449XBurns William R · Greensboro, GABuilt 1962 · S/N 18254138N4449YTx Waste Ventures LLC · Caddo Mills, TXBuilt 1975 · S/N E-657N4449ZStenga James E · Soldotna, AKBuilt 1969 · S/N 18-8796N444AASipola Don H · Virginia, MNBuilt 1973 · S/N 18261920
Back to AD 2007-04-19 R1