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.
N3752NEdwards Joseph David · Seattle, WAN3752QProp Setters LLC · Memphis, TNN3752TSharp Jim C · Stephenville, TXN3752URegistered aircraftN3752ZFowler Brad E · Hood River, ORN3753MEighties Aviation LLC · Wilmington, DEN3753PKarcic Tony M · Prescott, AZN3753THalcyone Holding LLC · Santa Teresa, NMN3753YWolfe Christopher D · Gilbert, AZN3754DEckard Eric M Trustee · Wasilla, AKN3754TWells Brian T · Gonzales, TXN3754WHam Aviation LLC · Maysville, KYN3754YSullivan Eugene M · Cotter, ARN3755Aerospace Trust Management LLC Trustee · Wilmington, DEN3755MEshleman James E · Yucaipa, CAN3755TAmr Pilot Services LLC · Jersey City, NJN3755UHendrickson Justin R · Twin Falls, IDN3755WMs Air LLC · Hickory, NCN3755XRegistration Pending · Casper, WYRegistration pendingN3755YCecil Enterprises LLC · Gig Harbor, WAN3756DAnderson Daren J · Almond, WIN3756PCreech William A · Selma, ALN3756REllington Christopher T · Owenton, KYN3756UKlinger Cattle Co Inc · Friona, TXN3756WAranda Jarrod A · Vancouver, WAN3756XStephens Tanner B · Palmer, AKN3757HCrouch Michael G · Brazoria, TXN3757KSkylux Aviation LLC · Coppell, TXN3757PCollura Joseph T · Glenwood, NJN3757TA&P Paul LLC · Columbia, CTN3757WSowden Nathan S · Annapolis, MDN3758CDodson International Parts Inc · Rantoul, KSN3758DStrother John G · Kenai, AKN3758QHalley Douglas H · Shelton, CTN3758XSteenrod Kenneth Alroy · Parsons, KSN3759FCoates Joseph M Jr · Tallapoosa, GAN3759NRuffner Jay P · O Fallon, ILN3759PHoffa John C · South Bend, INN3759QJ & C Companies LLC · Mesa, AZN3759TVelez Jose C · Port Orange, FLN3759YManagement Support Services LLC · Naturita, CON375BDHans Wolfgang Grotendiek Lc · Dorr, MIFirst renewal noticeN375BFDb Aviation LLC · Walnut Creek, CAN375BLBlue Line Aviation LLC · Smithfield, NCN375CDAtlantic Marine Construction Co Inc · Virginia Beach, VAN375FDepartment Of The Interior · Boise, IDN375GMMaitlen Gregory A · Aurora, CON375HPCraig E Rappe · Wasilla, AKN375HWWallace Charles · Fayetteville, ARN375JKGoff David D · Chilhowie, VA
Back to AD 2007-04-19 R1