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.
N28054Lemmerbrock Carl E · Northport, ALN28055Anthony Piccione LLC · Belleview, FLN28056Locker Dan L · Early, TXN28057Christensen John C · Livermore, CAN28058Warren Rex E · Bolivar, MON28059Ruiz Marcos · Bradenton, FLN2805AWeibert Jarvis Tye · Kalispell, MTN2805KNorthstar E & C LLC · Anchorage, AKN2805QA L Hollandsworth LLC · Columbia, MON28060S & D Stevens Farms LLC · Tillar, ARN28061Jug Aviation Inc · Detroit, MIN28062Alger Mark D · Friday Harbor, WAN28064Reis Darrin C · Fort Myers, FLFirst renewal noticeN28065Cae Aviation Academy Phoenix LLC · Mesa, AZN28066Usher Carolyn L · San Bernardino, CAN28067Gifford Craig E · Minneapolis, MNN28068Jeffrey V Clark · Libertyville, ILN28069Cae Aviation Academy Phoenix LLC · Mesa, AZN2806AJackson Todd M · East Wenatchee, WAN2806EBexar Aviation LLC · San Antonio, TXN2806MCondor Aero Club Inc · Zelienople, PAN2806QLawson Lance J · Sikeston, MON2806TN2806t Leasing Company LLC · Mason, MIN2806YPautler Justin H · Alden, NYN28073Lindinger John I · Auburn, NEN28078Stabs Aviation Enterprises LLC · Tulsa, OKN28079Abadir Peter · South River, NJN2807AWoodley Aerial Leasing LLC · Walnut, ILN2807EMission One LLC · Excelsior, MNN2807KLeseberg Mark E · Minden, NVN2807QReynolds David F · Port Orange, FLN2807RHayzan Aviation LLC · Wilmington, DEN2807TSale Reported · Broxton, GASale reported, canceledN28081Hardin David A · Tukwila, WAN28082Torrey Daniel B · Santa Paula, CAN28085Sale Reported · Falcon Heights, MNSale reportedN28086Cae Aviation Academy Phoenix LLC · Mesa, AZN28088Cae Aviation Academy Phoenix LLC · Mesa, AZN2808KCam Corporation · Fairbanks, AKN2808PValiair Limited Co Trustee · Casper, WYN2808RInman Matthew · Gallatin, TNN2808UCoastal Flight Inc · Half Moon Bay, CAN2808WParker David G · Sedona, AZN2809Piper Aircraft Inc · Vero Beach, FLN28090Cae Aviation Academy Phoenix LLC · Mesa, AZN28091Skinner David W · Georgetown, TXN28093Ceynowa Wayne S · Opelika, ALN28095Cae Oxford Aviation Academy Phoenix Inc · Mesa, AZN28096Cae Aviation Academy Phoenix LLC · Mesa, AZN28097Long Gordon W · Fort Wayne, IN
Back to AD 2007-04-19 R1