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.
N2775PMccann John P III · Greenville, PAN2775QRay Chris J · Ironside, ORN2775RMiller David · Tyler, TXN2775TWarner Jason David · Roseville, CAN2776AMccarthy Brian P · Yonkers, NYN2776EAugusta Flying Club Inc · Martinez, GAN2776FBabovic Slobodan · Elm Grove, WIN2776GOliver Charles D · Saint Albans, WVN2776TGeorge John S · Abiquiu, NMN2776WBowers Curt E · Jennings, LAN2776XSmith James A III · Millerton, NYN2776YMadlener Michael J · Las Vegas, NVN2777AEagle Equity Inc · Valparaiso, INN2777BHollister Jet Center Inc · Hollister, CAN2777ETop Flight Aviation Inc · Corona, CAN2777GPacheco Randy L · Pacific Grove, CAN2777JFirst Flight LLC · Craig, AKN2777PChilds Patrick S · Jasper, TNN2777TAviator Air Flight School LLC · Grand Prairie, TXN2777XKruskie Douglas · Petoskey, MIN2778FHuber George M · Bentonville, ARN2778JWilfer Dennis M · Fairbanks, AKN2778KDeloach Albert D · Del Valle, TXN2778THavrick Jason T · Bridgeport, TXN2779FSweatt D Wayne · Memphis, TXN2779PLaabs Donald L · Anchorage, AKN277ASproul Wendell C · Hermon, MEFirst renewal noticeN277ABSky West Aviation Inc Trustee · Albuquerque, NMN277AMParis Air Inc · Vero Beach, FLN277BKielty Ronald E · Ocala, FLN277BCCrain James B · Enid, OKN277BDCarroll David E · Buford, GAN277CBN277cb LLC · Jacksonville, FLN277CHHatz Aviation LLC · Pompano Beach, FLN277CKJones Doug L · Senoia, GAN277CPAirmart Inc · Lexington, KYN277CTRoss Peter W Trustee · Lufkin, TXN277DDWicked Flyby LLC · Lewes, DEN277DECooler Rick D · Fleming Island, FLN277FRowland Maxwell J · League City, TXN277GTSvetfur Aviation LLC · Camden, SCN277JKcsi Aerial Patrol Inc · Bakersfield, CAN277JMN541mg Inc · Big Pine Key, FLN277LCN277lc LLC · Fairbanks, AKN277LGAb Prop Plane I LLC · Metairie, LAN277LMRegistration Pending · Bend, ORRegistration pending, pending cancellationN277MFrattasio Damian E · Pembroke, MAN277MANickell Paul D · Milo, IAN277MCSidhu Hs · Anaheim Hills, CAN277MDRegistered aircraft
Back to AD 2007-04-19 R1