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.
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
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.
N4443PRealtime Consulting LLC · Winter Park, FLN4443QSkyborne Airline Academy Inc · Vero Beach, FLN4443RCold Region Air LLC · Fairbanks, AKN4443TKristofzski John · West Richland, WAN4443XFox Two LLC · Camino, CAN4443ZMeekin Michael J · Palmer, AKN44441Breeden William N · Gaithersburg, MDN44442Cummins Stephen Michael · Fenton, MON44443Jax Navy Flying Club · Jacksonville, FLN4444AWesolowski Chris E · Anchorage, AKN4444EIllsley Roger J · Santa Rosa, CAN4444JMoore James Jeffrey · Midlothian, TXN4444KSivyllis Costas · Port Orange, FLFirst renewal noticeN4444MTurbine Conversions Ltd · Nunica, MIN4444TKinzie Industries LLC · Alva, OKN4444WKoehler Robert E · West Lafayette, INN44450Brown Roy A · Morongo Valley, CAN44452Cdr Aviation LLC · Kalispell, MTN44458Forsman Airways LLC · Glenwood, MNN4445JSkyborne Airline Academy Inc · Vero Beach, FLN4445KSkyborne Airline Academy Inc · Vero Beach, FLN4445PSkyborne Airline Academy Inc · Vero Beach, FLN4445SSkyborne Airline Academy Inc · Vero Beach, FLN4445VSkyborne Airline Academy Inc · Vero Beach, FLN4445YSkyborne Airline Academy Inc · Vero Beach, FLN44463Sabine Financial Services Inc · Wilmington, DEN4446JScherr Steven · Mandan, NDN4446RSiler Jerry L · Eau Claire, WIN4446ZGrant Kimberly A · Priest River, IDN44478Richard J Farmer II · Fremont, OHN4447ASouth Texas Helicopter Services LLC · Mcallen, TXN4447QWolter Dennis R · Cincinnati, OHN4447RManos Con Alas Ministries · Sierra Madre, CAN4447VTurkey Holler LLC · Shamrock, TXN44485Registration Pending · Middletown, OHRegistration pendingN44488Daris James · Fitzwilliam, NHN4448HNorthwest Iowa Flyers LLC · Everly, IAN4448RBell F Robert · Anchorage, AKN4448THoughton John L · Lamar, MON4448ZGrow Michael J · Palmer, AKN44497English William E · Mason City, IAN4449GHuntley John · Bellingham, WAN4449JSinatra Anthony J · Glendale, AZN4449RMorrow David · Maynardville, TNN4449SMccutchen John J II · Houston, TXN4449WJameson Clarke Enterprises LLC · Houston, TXN4449XBurns William R · Greensboro, GAN4449YTx Waste Ventures LLC · Caddo Mills, TXN4449ZStenga James E · Soldotna, AKN444AASipola Don H · Virginia, MN
Back to AD 2007-04-19 R1