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.
N36409Wire Wonder Inc · New York, NYNon-citizen corporation, flight hours not reportedN3640GTailwind Flight Center - Sue LLC · Sturgeon Bay, WIN3640NShaikh Samir K · Schaumburg, ILN3640QBenville Pete E Jr · Boonville, CAN3640UMarkle Raymond J · Madawaska, MEN3640XDoerhoff Daniel L Trustee · Lone Jack, MON3640ZElliott Frank F · Mojave, CAN36411Runsick Michael C · Wynne, ARN36413Steward James D · Monument, CON36414Dewitt Elvin H · Santa Monica, CAN36417Huber Weylin L · Aberdeen, SDN3641BUnity Aero Of Delaware LLC · Dover, DEN3641CFeldmann D Joshua · Epworth, IAN3641DAdkins Steven · Oriental, NCN3641MSweet Water Air LLC · Kissimmee, FLN3641NVilliger Arnold H · Henry, ILN3641RGeorge Walker Field Inc · Bedminster, NJN3641SHolzsweig Leon G · Dallas, TXN3641WMitchell Jeffrey Scott · Donalsonville, GAN3641YVictoria Jet Aviation LLC · Victoria, TXN36424Fmy Inc · Honolulu, HIN3642CMcmahan Bryan · Gakona, AKN3642DCorre Training Industries Inc · Federal Way, WAN3642MCraig James P · Jacksonville, ARN3642PSkyranch Knoxville Youth Inc · Knoxville, TNN3642QPorte Elvis · Miami, FLN3642UPm Barrett Aviation LLC · Tucson, AZN3642WMasia Matt D · Paso Robles, CAN36434Phillips Aaron W · Fort Scott, KSN36438Dorman Richard E · Mesa, WAN3643BCoffelt Kelly L · Bend, ORN3643DNevins Robert · North Palm Beach, FLN3643MKing Jay M · King Salmon, AKN3643NHoward Trae · San Antonio, TXN3643TBds Flyer LLC · Middletown, DEN3643UN3643u Aviation LLC · Denver, CON3643XBurbey Mark G · Racine, WIN3644KDraheim Allan C · Lagrange, GAN3644PHanselmann Seth · Lincoln, VTFirst renewal noticeN3644RRegistration Pending · Sarasota, FLRegistration pendingN3644ULawrence Carl E · Boulder, CON36456Charles Ho Consultants LLC · Beverly, MAN3645UHusaim John Steven · Hohenwald, TNN3645WDodson International Parts Inc · Rantoul, KSN3645XAubrey James M · North Little Rock, ARN3646063nl LLC · Willmar, MNN3646HAdams Toby R · Paris, TXN3646KParrish Doug · Monument, CON3646PMr Group · Rapid City, SDN3646UGarner Lynn · Preston, ID
Back to AD 2007-04-19 R1