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.
N3477XCoulter Jack E · Chapel Hill, NCN34787Baker Herman L · Austin, TXN3478KYarber Brandon Tate · Cleveland, TNN3478QCsc Aviation LLC · Parker, CON3478TGuzowski Richard G · Haydenville, MAN3478WDouble D Air LLC · Killeen, TXN3478XCleveland Andrew D · Vancouver, WAN34794Schmidt Gary L · Afton, MNN34795Fox Business Advisors LLC · Mesa, AZN34796Masters David R · Troy, KSN3479RM S Davidson Enterpries Pc · Laurel, DEN3479SCook Mark C · Hutto, TXN3479TRobbins Derick Mitchell Robbins · Freeport, FLN3479WMccurdy Robert Kelly · Glendale, AZN3479XFrontier Land & Cattle LLC · Ozark, MON3479ZPhegley James R · Carlisle, INN347ABTropical Transport Services Ltd Inc · San Juan, PRN347BGBowling Green Flight Center LLC · Bowling Green, OHN347CDCulkin Daniel J Trustee · Edmond, OKN347CHAce Flight Center · St Thomas, VIN347DProfessional Training Aircraft LLC · Wilmington, DEN347DMSpivey Ricky S · Samson, ALN347ECallahan Kevin Michael · Des Moines, WAN347GDNye Brian M · Independence, ORN347GWAllen Air LLC · Creola, ALN347JADepete Joseph G · Louisville, KYN347JPPhantom Flyer LLC · Yelm, WAN347MKNorth Star Aviation · Mankato, MNN347RAAdamson Matthew C · Sherwood, ARN347RPRegistration Pending · Daytona Beach, FLRegistration pending, canceledN347STGraber Joel C · Collins, MSN347TMccartney Matthew T · Lake Tapps, WAN347WGMt Aircraft LLC · Port Orange, FLN347ZCasey John T · Shenandoah, TXN34808Barber Jeffrey A · Blaine, MNN34809Grassmyer Richard M · Salem, INN3480FAltus Aircraft LLC · Taylor, TXFirst renewal noticeN3480K3480k LLC · Waycross, GAN3480TMoffatt Thomas O Jr · Diberville, MSN3480USoule Clauson D · Cooperstown, NYN3480XLorenzi Mark E · Lancaster, OHN34813Max Gs LLC · Wilmington, DEN34816Clark Tal O · Hudson, CON34818Rosenberger Mark W · West Columbia, SCN3481FWells Garry L · Scotia, NEN3481SDorman Richard E · Mesa, WAN3481TEstes Kenneth · Portland, ORN3481USmith Lowell A · Gresham, ORN3481WSandpiper Air LLC · Charles Town, WVN3481XN3481x LLC · Reno, NV
Back to AD 2007-04-19 R1