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.
N4706LKings Heir Inc · Kent, WAN4706QRegistration Pending · Polson, MTRegistration pendingN4706SGreat Lakes Aviation LLC · Burtchville, MIN4707ASherman Aviation Inc · Redmond, ORN4707BOlathe Spray Service Inc · Olathe, CON4707CSmith James A · Lyle, WAN4707JBeck Joseph P II · Pollock, LAN4707KKcsi Aerial Patrol Inc · Bakersfield, CAN4707SBas Part Sales LLC · Greeley, CON4707TVan Ausdall John C · Spring Branch, TXN4707UZero Seven Uniform LLC · Palmer, AKN4707YWengair LLC · Powell, WYN47084Tabor Peter C · Durango, CON4708AFranz Stanley · Yakima, WAN4708LAlexander Nicholas R · Oak Hill, OHN4708NSkylane LLC · Billings, MTN4708QCole Brent R · Anchorage, AKN4708VSpears Patricia C · Longmont, CON47093Skipper Consulting LLC · Athens, ALN4709DMagalsky Jacob J · Wilsall, MTN4709KAlexander & Knizley Inc DBA · Mobile, ALN4709LJohannsen Michael R · Allen, TXN4709RG & M Aircraft Inc · Wheat Ridge, CON4709SMolinar Antonio L · El Paso, TXN470AArcher Aircraft LLC · Wilmington, DEN470AKAkima Logistics Services LLC · Usaf Academy, CON470AWWhitesell Paul Trustee · Plano, TXN470BCCorvus Flight LLC · Salinas, CAN470CBoese Jon D · Holloway, MNN470CDPrecision Machine Tool Solutions LLC · Sinking Spring, PAN470CMWooden Wings LLC · Prescott, AZN470EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN470FLBaker Brian K · Dayton, OHN470FSCustom Air International LLC · Homestead, FLN470HPBloch Christopher P · Grand Rapids, MIN470JCCox Patrick A · Torrance, CAN470JKHill Kenneth R · Port Charlotte, FLN470JSShort Jeffery G · Cottonwood, CAN470KCColeman Keith T · Mukilteo, WAN470KMAv Chase LLC · Kirtland, OHN470MAKek Companies Inc · Portland, ORN470MJLong John D · Lake Wylie, SCN470PGreentree Aviation LLC · Sewell, NJN470RPDaytona Aircraft Services Inc · Daytona Beach, FLN470RVFlyguys Aviation LLC · Bay City, MIN470SHopkins William C · Reno, NVN470UNew Horizon Aviation Inc · Warwick, RIN470XSale Reported · Priest River, IDSale reportedN4710LStuhmer Samuel K · Central City, NEN4710QNeitz Frank A · Bethel, AK
Back to AD 2007-04-19 R1